H ow do I add time (h:mm) that is a sum of calculations

A

arcticron

I have built a time card where I calculate start and stop times using
standard times, (not military which would be a no brainer) I use the
following formula: =text(a2-a1),"h:mm" for total time for a day. I wish now
to total each day but can not
add the sum.
 
A

Aladin Akyurek

Switch from

=text(a2-a1),"h:mm"

to:

=A2-A1

and sum the range of interest while the cell housing the sum is custom
formatted as [h]:mm.
 
Top