I have a foumula that works fopr lunches on a day shift 6am-4:30pm but I cant seem to get it to work on the second shift that runs 6pm-5am.
He is what I have….
=(G10-F10)*24-IF((G10-F10)*24>4.5,0.5) works for days....
I have a foumula that works fopr lunches on a day shift 6am-4:30pm but I cant seem to get it to work on the second shift that runs 6pm-5am.
He is what I have….
=(G10-F10)*24-IF((G10-F10)*24>4.5,0.5) works for days....
This should work for both day and night shift:
=(MOD(G10-F10,1)-IF(MOD(G10-F10,1)*24>4.5,30/1440))*24
Format as General or Number
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
You rock!!!
Thank you and I mean that!
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks