Using excel as a time clock

S

Sue Minuth

How can I make excel work as a time clock. I want to have
a spreadsheet showing, for example, someone works from
10:32A.M. until 7:32P.M. I need a formula column saying
how many hours this totaled.

Help and thank you.
 
J

J.E. McGimpsey

XL stores times as fractional days (e.g., 3:00 = 0.125), so you can
add and subtract, with the caveat that at midnight 0.999..
(23:59:59.. or 11:59:59..PM) becomes 0, so you need to account for
the change.

One way:

A1: 10:32 AM
A2: 7:32 PM
A3: =A2-A1 ==> 8:00

when A3 is formatted as h:mm

If the times may span midnight, use:

A3: =MOD(A2-A1,1)

See

http://cpearson.com/excel/datetime.htm#AddingTimes

for more.
 
Top