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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculate the difference between 11:00pm and 7:00am 3
h:mm to decimal value 4
Time calculations for Scheduled Time vs. Actual Time Worked 1
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Time calculations for Scheduled vs Actual Employee Time and Wages 2
Running a macro based on the time 1
Time formula (difference of predicted and actual time) 6
Calculating Time 6

Back
Top