Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Timesheet function in Excel
Is there a function in Excel to calculate time like on a timesheet for
payroll purposes? I don't want to buy special software to do this and I'd rather not have manual processes. |
#2
|
|||
|
|||
If you set it up correctly, time calculates with simple additions and
subtraction. Try this web site for some general information. http://www.contextures.com/xlfaqDat.html In particular, the link to Chip Pearson's site is very useful to help understand how time and dates are stored. Steve "RM" wrote in message ... Is there a function in Excel to calculate time like on a timesheet for payroll purposes? I don't want to buy special software to do this and I'd rather not have manual processes. |
#3
|
|||
|
|||
Have a look at Chip Pearson's site for example sheet.
http://www.cpearson.com/excel/overtime.htm Also check out the Templates at the template gallery. http://office.microsoft.com/en-us/te...377091033.aspx Gord Dibben Excel MVP On Wed, 13 Apr 2005 21:56:02 -0700, "RM" wrote: Is there a function in Excel to calculate time like on a timesheet for payroll purposes? I don't want to buy special software to do this and I'd rather not have manual processes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
Is there a Timestamp function that does not update in Excel? | Excel Worksheet Functions | |||
Return value with using Excel function | New Users to Excel | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Missing function in Excel 2003 | Excel Discussion (Misc queries) |