My Assistant
Site Message
(Message will auto close in 2 seconds)
 Converting Seconds, Summing, Office 2007
|
|
 Apr 29 2010, 09:41 AM
Post
#1
|
|
|
UtterAccess Enthusiast Posts: 74 From: Indiana  |
I know this is another of those elementary things I am just missing.
In the detail section of my report I have a field [Duration]. Duration represents seconds. In the report footer I have a the sum of Duration, or =Sum([Duration]). I would like to add in the Detail section of the report an expression which will take [Duration] and convert it to hh/mm/ss. I would like to add in the Report Footer section of the report an expression which will take my sum of [Duration] and convert it to hh/mm/ss.... keeping in mind, this may be over 24 hours. Suggestions? |
 |
 
|
 |
Replies
|
Apr 29 2010, 12:11 PM
Post
#2
|
|
|
Access Wiki and Forums Moderator Posts: 48,642 From: SoCal, USA |
Hi All,
Sounds like fun. Here's my "lazy" take on it: CODE =[Duration]\3600 & ":" & ([Duration] Mod 3600)\60 & ":" & [Duration] Mod 60 Cheers (IMG:style_emoticons/default/cheers.gif) |
|
|
|
Posts in this topic
danbouton Converting Seconds, Summing Apr 29 2010, 09:41 AM
RAZMaddaz Here is a Link to a Microsoft Function called ... Apr 29 2010, 10:20 AM rbianco I wanted the excercise and came up with this durat... Apr 29 2010, 10:26 AM
doctor9 Apparently it's a slow day here at UA. He... Apr 29 2010, 10:28 AM
danbouton QUOTE (rbianco @ Apr 29 2010, 11:26 AM) I... Apr 29 2010, 12:28 PM danbouton QUOTE (theDBguy @ Apr 29 2010, 01:11 PM) ... Apr 29 2010, 12:29 PM theDBguy QUOTE (danbouton @ Apr 29 2010, 10:29 AM)... Apr 29 2010, 12:54 PM RAZMaddaz RE: Converting Seconds, Summing Apr 29 2010, 12:31 PM rbianco While I "technically may have "won... Apr 29 2010, 01:14 PM theDBguy QUOTE (rbianco @ Apr 29 2010, 11:14 AM) W... Apr 29 2010, 01:22 PM |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 19th June 2013 - 10:07 PM |