So I've been trying to figure out a formula for how to determine if an employee worked at least 4 hours of overtime. I use military time and also have to calculate overnight staff, plus a half hour unpaid break for employees that work at least 6 hours. I've attached a file as an example. Any help would be greatly appreciated!
New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
Calculate Day/Night Shifts using Military Time with 4 hour difference
1 post
• Page 1 of 1
Calculate Day/Night Shifts using Military Time with 4 hour difference
by megadp » Fri Mar 25, 2016 5:19 pm
- 0
You do not have the required permissions to view the files attached to this post.
- megadp
- Rookie
- Posts: 1
- Joined: Mar 25, 2016
- Reputation: 0
- Excel Version: 2016
1 post
• Page 1 of 1
Return to General Excel Questions
Who is online
Users browsing this forum: Google [Bot] and 6 guests