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

TIME CALCULATION 5
Time Sum in Excel 1
Payment calculation 1
formula for sum 3
Calculate the difference between two times - getting '#VALUE!' err 2
Calculate the difference between two times and show dd:hh:mm:ss 7
Calculating Time from Speed and Distance? 3
Subtracting time 5

Back
Top