Adding time

[Jack R]

I am trying to do a work scehdule on Excel, i have a cell
for start time and one for end time, I am using this
formula TEXT(C2-B2,"h:mm")to determine the hours
scheduled. Now I need to add the total hours scheduled
each day for a total for the week, i.e. 32.5 hrs. Waht is
the formula and format that I need so I can add the hours
as a decimal as shown above.
Any help would be gratefull.

 

[J.E. McGimpsey]

If you don't need your first result to be Text, you could just use
=C2-B2 and format the cell as a time.

XL stores times as fractional days (e.g., 6:00 = 0.25) so to get
32.5 hours, just multiply your sum by 24:

A8: =SUM(A1:A7)*24

and format as a number. See

http://www.cpearson.com/excel/datearith.htm

for more.

 

[Amey]

Dear Jack,

I am trying to do the same type of thing, a Time Clock in
my case. Has anyone anwered your question yet? If so,
could you please forward it to me. It would be greatly
appreciated.

Thanks,

Amey