how do I sum time difference

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

Guest

I am trying to calculate the difference between two times and sum the
differences. For example: in cell b2 I have 10:00 AM, in cell c2 I have 6:00
PM. In cell a1, I use the formula =TEXT(c2-b2,"h:mm"). In cell a1, it does
display 8.00. However, when I sum this 'a' column, it does not show it. It
is a blank value.

My goal is to sum my weekly work schedule of hours and minutes worked, and
then have a cell times it by my hourly rate.

Anyone good at this one?
 
Don't use the text function! That's taking numbers (which can be added) and
turning them into strings (which cannot). Just use =c2-b2 and format the
result as appropriate. Then sum the column and use the custom number format
[h]:mm for the total.
 
Back
Top