Hi all,

How to calculate night time over midnight. Night time means 22:00-06:00.
Please see attached excel file.

Formula at D18 is ok when stop time is between 24:00. But stop time above 24:00 result is 0:00.
This is time only situation.

Please help me for solve this problem.

salary_production12_12test.xlsm