In a time sheet I have created, there is
start/end work time which works O.K.
My problem is, that between 0:00 and 6:00
(night shift) there is different pay rate, so I have
to calculate those night hours (using IF
expression, I believe....) and represent day
and night working hours separately.
Question: how to make formula checking the
"End Work" before midnight and split working
hours in 2 different cells?