Double over time formula help?
Hi so I'm an intermediate level excel user and I have to calculate double over time >>>
The formula I have right now is to calculate over time after 8 hours
D1 is starting time and E1 is ending time (24 hour clock)
=IF((E1-D1+(E1<D1))*24>8, (E1-D1+(E1<D1))*24-8,0)
I have to make this DOUBLE over time, and I'm having a lot of trouble...
Any suggestions?
The formula you quoted calculates the overtime hours - what do you need to do differently - examples always help.........
Audere est facere
hmm so right now that formula calculates regular over time
=IF((E1-D1+(E1<D1))*24>8, (E1-D1+(E1<D1))*24-8,0)
so start time 12:00 (cell D1) | end time 9:30 (cell E1) | over time = 1.5 hours
I need it to be doubled...
start time 12:00 (cell D1) | end time 9:30 (cell E1) | over time = 3 hours (double over time)
Sorry does that make more sense?
sorry its in 24 hour time so
so start time 12:00 (cell D1) | end time 21:30 (cell E1) | over time = 1.5 hours
Just multiplying the whole thing by 2 should do it
=IF((E1-D1+(E1<D1))*24>8, (E1-D1+(E1<D1))*24-8,0)*2
or this version should give the same result
=MAX(MOD(E1-D1,1)*24-8,0)*2
It is giving me a value of 0:00...
I will attach a worksheet maybe it will give you a better idea
It works for me.....
either this formula
=IF((E2-D2+(E2<D2))*24>8, (E2-D2+(E2<D2))*24-8,0)*2
or this one
=MAX(MOD(E2-D2,1)*24-8,0)*2
either way format cell to show number and you should see 3.0
huh weird... it works now lol
THANK YOU THANK YOU THANK YOU :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks