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.

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.

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.