I have a spreadsheet built with formulas to automatically calculate for overtime/callout pay for crews. The crews get a minimum of 3 hours call out on Saturdays & Sundays and after 4 pm each regular work day. I have the formula that works for columns G & H Monday - Friday and A - H for Saturday & Sunday's but does not work for column I & J. I am attaching spreadsheet and this is the formula I am using:
=IF(C3="",0,MAX(3,(D3-C3+(D3<C3))*24))+IF(E3="",0,MAX(3,(F3-E3+(F3<E3))*24))+IF(G3="",0,MAX(3,(H3-G3+(H3<I3))*24))+IF(I3="",0,MAX(3,(J3-I3+(J3<I3))*24)) This one is for weekend
=IF(G3="",0,MAX(3,(H3-G3+(H3<I3))*24))+IF(I3="",0,MAX(3,(J3-I3+(J3<I3))*24))This one is for Monday - Friday regular work day
Do I have something entered incorrectly?
Bookmarks