how do I sum time difference

  • Thread starter BenjaminRamalho
  • Start date
B

BenjaminRamalho

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

bpeltzer

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.
 
Top