Totaling Times

[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??

 

[KARL DEWEY]

Try this --
Sum(CDbl(DateDiff("n", [Start Time], [Finish Time])\60 & "." &
Format(DateDiff("n",[Start Time], [Finish Time]) MOD 60, "00")))

 

[John W. Vinson]

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??

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.