Thread: [Solved] Determine overtime/nighttime for time sheet
View Single Post
 
Old 06-03-2015, 06:36 AM
sigma sigma is offline Windows 8 Office 2010 64bit
Novice
  
Join Date: Jun 2015
Posts: 2
sigma is on a distinguished road
Default Determine overtime/nighttime for time sheet
I am trying to make a time sheet with 2 rows. One for normal hours and one for over time.
I have manage to create a formula for overtime over 8 hours, but I am not sure how to make the formula for over time between 21-06.

Can anyone help?

Rules:
Normal hours: 8
Over time: Work over 8 hours
Night time (over time) between: 21-06

Uploaded attachment
Attached Files
File Type: xlsx Timesheet-need-help.xlsx (17.6 KB, 13 views)
Last edited by sigma; 06-03-2015 at 01:06 PM. Reason: Remove ext link
Reply With Quote