LinkBack URL
About LinkBacks
6:00 PM 12:30 AM -17.5
=(P9-O9)*24-IF((P9-O9)*24>6,1,IF((P9-O9)*24>6,0.5,0))
Im trying to deduct an hour break and show total shift time, but im cant seem to get the correct formula
Need help deducting an hour lunch break while also showing the total total shift hour tot.
6:00 PM 12:30 AM -17.5
=(P9-O9)*24-IF((P9-O9)*24>6,1,IF((P9-O9)*24>6,0.5,0))
Im trying to deduct an hour break and show total shift time, but im cant seem to get the correct formula
withdrawn..
Last edited by protonLeah; 12-24-2015 at 03:12 PM.
Ben Van Johnson
Maybe..
=((P9<O9)+(P9-O9)-IF((P9<O9)+(P9-O9)>0.25,1,0.5)/24)*24
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks