How do you subtract time as in a timecard to calculate hours work
Is there a template out there that calculates time for hours worked.
|
How do you subtract time as in a timecard to calculate hours work
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 "Dave Davis" <Dave wrote in message ... Is there a template out there that calculates time for hours worked. |
How do you subtract time as in a timecard to calculate hours work
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. -- Regards Roger Govier "Dave Davis" <Dave wrote in message ... Is there a template out there that calculates time for hours worked. |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com