Adding Time in Excel

[lskidmore]

I have an employee that records her time worked for a
subsidiary each day. I would like to be able to calculate
her monthly time spent on the subsidiary since we have to
transfer her costs each month. Is there a formula that we
can use to calculate the time worked?

For Example her excel schedule looks like:
9/8/03 8:00 a.m. 10:45 a.m.
9/9/03 11:45 a.m. 3:15 p.m.
etc.

Thank you,

 

[Bob Phillips]

Assuming that you don't have breaks in there to account for, just use
=SUM(C1:C100)-SUM(B1:B1000)
and format as [h]:mm,
or if you want as decimal hours, multiply by 24