Adding cells that have a formula with time in them

[Michelle]

I have finally figured out how to add time in Excel for one day. For
example starting work at 8:00 am and ending at 5:00 pm with one hour
lunch. The total is 8 hours. But HOW do I add the formula column at
the end of the week to come up with 40 hours? I've spent way to much
time on this. You would think Microsoft could figure out how to not
make this so difficult. Can anyone help??



------------------------------------------------
Message posted

-- View and post Excel related usenet messages directly from http://www.ExcelForum.com
at http://www.ExcelTip.com/
------------------------------------------------

 

[rob]

Time in excell is counted in days.
Jan 1, 1900 = 1
Jan 1, 2000 = 36526
1 year = 365.00
1 hour = 1/24 = .041667

If your result is in excel format, then 8 hours = 8/24 =
0.66667

In that case, just add them up and format the result cell
to hh:mm

if you result is currently raw data, i.e. displayed 8
hours numerically = 8.00, then add them all up just as
they are.

Perhaps you could give me more detail as to what you've
already done...

Here is an excellent site about tricks with time in excel:
http://www.cpearson.com/excel/datedif.htm

-----Original Message-----
I have finally figured out how to add time in Excel for one day. For
example starting work at 8:00 am and ending at 5:00 pm with one hour
lunch. The total is 8 hours. But HOW do I add the formula column at
the end of the week to come up with 40 hours? I've spent way to much
time on this. You would think Microsoft could figure out how to not
make this so difficult. Can anyone help??

from http://www.ExcelForum.comat http://www.ExcelTip.com/

 

[Ron Rosenfeld]

I have finally figured out how to add time in Excel for one day. For
example starting work at 8:00 am and ending at 5:00 pm with one hour
lunch. The total is 8 hours. But HOW do I add the formula column at
the end of the week to come up with 40 hours? I've spent way to much
time on this. You would think Microsoft could figure out how to not
make this so difficult. Can anyone help??



------------------------------------------------
Message posted

-- View and post Excel related usenet messages directly from http://www.ExcelForum.com
at http://www.ExcelTip.com/
------------------------------------------------

It's not that hard to do the addition:

Start End HrsWrkd
8:00 AM 5:00 PM 8:00
6:00 AM 2:00 PM 7:00
10:00 AM 1:30 PM 2:30
8:00 AM 4:30 PM 7:30
9:00 AM 5:00 PM 7:00



The formula for the HrsWrkd column is:

=End-Start-TIME(1,0,0)

Then all you have to do is SUM(HrsWrkd)

Format the cell as [h]:mm to prevent the rollover at 24 hours.



--ron