Question: how to calculate time difference in excel over midnight?
Answer: =end-start =5:00PM-8:00AM =0.375-0.708=.333//8hours. =1-start+end. =IF(end>start, end-start, 1-start+end) =MOD(end-start,1) =end-start. =C5-B5.