Night Differential

Originally Posted by Sadath31

Hi t
=(MIN(TIMEVALUE("6:00:00"),MOD(B2,1))+1)-MAX(TIMEVALUE("22:00:00"),MOD(A2,1))

Hi Sadath31, I tried this formula. It is working when the time in is 11:00 PM and time out is 6:00 AM but does not work when I changed the time in to 1:00 AM and time out to 6:00 AM.