Calculating hours in a timesheet xls

  • Thread starter Thread starter David Lewis
  • Start date Start date
D

David Lewis

I am doing a timesheet.
I need to total the hours worked in a day, but if the sumed hours exceed 8 hours then I need to total to display 8 and
the next cell to display the hours over 8.

For example: If I work 11 hours then "total regular hours" would display 8 and "OT hours" would display 3.
But if I only worked 6 hours then "total regular hours" would display 6 and "OT hours" would display nothing.

How to do this?
 
Dave, check this out.

http://www.cpearson.com/excel/overtime.htm



David Lewis said:
I am doing a timesheet.
I need to total the hours worked in a day, but if the sumed hours exceed 8
Click to expand...
hours then I need to total to display 8 and
the next cell to display the hours over 8.

For example: If I work 11 hours then "total regular hours" would display
Click to expand...
8 and "OT hours" would display 3.
But if I only worked 6 hours then "total regular hours" would display 6
Click to expand...
and "OT hours" would display nothing.
 
Back
Top