Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract time between certain days/work hours? | Excel Worksheet Functions | |||
How to write the formula for time accounting for a work schedule | Excel Worksheet Functions | |||
Time sheets | Excel Worksheet Functions | |||
calculate hours on work sheet | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions |