Timesheet function in Excel

[Guest]

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.

 

[Steve R]

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

 

[Gord Dibben]

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/templates/CT011377091033.aspx


Gord Dibben Excel MVP