Formula to seperate Reg Hours and Overtime

[Brumal]

I apologize for the Noobness, but I just recently started working with Excel. I am needing to know the best way to separate Regular and overtime for a 40 hour week. Employees enter in Hours and minutes manually in one range and it is currently sum'd into one cell. I am trying to get the daily hours, if over 8, to show just 8 and anything over the 8 to move into the next cell. So my end result will be Reg Hours total will always be 40, and any over 40 will be in the OT total cell. I have attached a copy of the timesheet. Again I apologize for my lack of knowledge, but I am in a time crunch, Any and all help will be greatly appreciated.

[gebobs]

Add another column, say "Time" or whatever, for the employees to enter their data. Then in the Reg cell, you would have the formula (for Monday Week 1):

Code: Select all

=MIN(C13,1/3)

And for OT:

Code: Select all

=C13-D13