Totaling Times

  • Thread starter Thread starter Derrick
  • Start date Start date
D

Derrick

Thanks to a great answer to my previous question on calculating time
differences i used the expression below;

DateDiff("n", [Start Time], [Finish Time])\60 & "." & Format(DateDiff("n",
[Start Time], [Finish Time]) MOD 60, "00")

Now what I need to know is how to total the results of multiple hours and
minutes shown??
 
Try this --
Sum(CDbl(DateDiff("n", [Start Time], [Finish Time])\60 & "." &
Format(DateDiff("n",[Start Time], [Finish Time]) MOD 60, "00")))
 
Thanks to a great answer to my previous question on calculating time
differences i used the expression below;

DateDiff("n", [Start Time], [Finish Time])\60 & "." & Format(DateDiff("n",
[Start Time], [Finish Time]) MOD 60, "00")

Now what I need to know is how to total the results of multiple hours and
minutes shown??
Click to expand...

Total the minutes *first*, and then use the same kind of formatting expression
to display the result:

Sum([runtime]) \ 60 & ":" & Format(Sum([runtime]) MOD 60, "00")

where runtime is the sum of the individual datediffs.
 
Back
Top