My Assistant
Site Message
(Message will auto close in 2 seconds)
have calculated elapsed time - now need to total elapsed time, Office 2007
 Jul 30 2010, 09:53 AM
Post
#1
|
|
|
UtterAccess Member Posts: 16  |
I have a report that calculated the elapsed time based on user input of startTime and endtime.
The report uses an Instant If to display the elapsed time for each event grouped by the person participating. I need to total the elapsed time and have it displayed as HH:MM. I have a Running Total box in the group footer, but it's not giving me accurate totals. Here's an example: Name date start end elapsed Doe, John 1/1/10 1000 1100 1:00 1/2/10 1415 1430 0:15 total 0:15 Next Group My Running Sum is set to Overall. What is the secret to adding time? Thanks in advance! Erick |
 |
 
|
 |
Replies
|
Aug 6 2010, 11:51 AM
Post
#2
|
|
|
UtterAccess Member Posts: 16 |
Thanks a ton!!
Works like a charm! Erick |
|
|
|
Posts in this topic
erick79015 have calculated elapsed time - now need to total elapsed time Jul 30 2010, 09:53 AM
Jeff B. Erick
I'm going to guess that you have that c... Jul 30 2010, 10:16 AM David Peel Hi Erick
In addition to Jeff's comments, what... Jul 30 2010, 11:03 AM erick79015 Okay, instead of getting wrapped around the axle o... Aug 5 2010, 10:55 AM Jeff B. You don't mention "how" you are tryi... Aug 5 2010, 01:47 PM erick79015 With the report in design view, I opened Group/Sor... Aug 5 2010, 03:39 PM David Peel Hi Erick
Are you able to attach a copy of your da... Aug 6 2010, 04:54 AM erick79015 Okey-Dokey
Here's the database (with test dat... Aug 6 2010, 09:48 AM David Peel Hi Erick
To make your subtotal work in the report... Aug 6 2010, 10:15 AM
 |
|
Go to Top · Lo-Fi Version | Time is now: 4th February 2012 - 11:33 PM |