|
|
#1
06-03-2015, 06:36 AM
|
|||
|
|||
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 Last edited by sigma; 06-03-2015 at 01:06 PM. Reason: Remove ext link 
|
|
#2
06-03-2015, 08:08 AM
|
||||
|
||||
|
Hi and welcome
as external links are potentially unsafe I removed the link to your file. But you can post the file on the forum. Much more people will be able to access it.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to Input Actual Overtime Work
|
caveman | Project | 13 | 03-31-2015 05:24 PM |
|
How to create a formula using the IF in a time sheet.
|
spaul | Excel | 3 | 10-28-2013 07:19 PM |
|
Sheet load time
|
markg2 | Excel | 2 | 06-01-2011 06:00 PM |
| Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |
|
Enter Number on any sheet one time only.
|
paulrm906 | Excel | 1 | 04-28-2006 07:35 AM |
Windows 8 
Office 2010 64bit
Linear Mode
