How do you subtract time as in a timecard to calculate hours work

[Guest]

Is there a template out there that calculates time for hours worked.

 

[Paul B]

Dave, see if this will help,

http://www.cpearson.com/excel/overtime.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul B]

Dave, see if this will help,

http://www.cpearson.com/excel/overtime.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Roger Govier]

Hi Dave

With start time in A1 and finish time in B1
=MOD(B1-A1,1)
will calculate the interval, even allowing for times that cross the
divide between one day and the next.
Excel store its times as fractions of a day, so if you need to multiply
hours by rate per hour, you first need to multiply the hours calculated
by the above formula by 24, to bring them to a decimal value.

 

[Roger Govier]

Hi Dave

With start time in A1 and finish time in B1
=MOD(B1-A1,1)
will calculate the interval, even allowing for times that cross the
divide between one day and the next.
Excel store its times as fractions of a day, so if you need to multiply
hours by rate per hour, you first need to multiply the hours calculated
by the above formula by 24, to bring them to a decimal value.