Forum Discussion
Solved
Night shift
Hi, I have a question ... how can a night shift be calculated automatically? I work from 9.30 pm to the second day at 9.30 am and at night I get paid $ 2 more between 10 pm and 6 am!
Here
it could be
day shift: =IF( D2 < C2, IF(C2>$A$1, 0, $A$1-C2) - IF(D2<$A$2,0, $A$2-D2), MIN(D2,$A$1) - MAX($A$2,C2) ) total: =MOD(D2-C2,1) night shift: =G2-E2
Sometimes I work from 02.44 to 12.00 or from 16.00 to 03.58 ...
Here
it could be
day shift:
=IF(
D2 < C2,
IF(C2>$A$1, 0, $A$1-C2) - IF(D2<$A$2,0, $A$2-D2),
MIN(D2,$A$1) - MAX($A$2,C2) )
total:
=MOD(D2-C2,1)
night shift:
=G2-E2- Thank you Sergei!!
gmarko11 , you are welcome