=MOD(D14-B14,1)*24 - 0.5*(MOD(D14-B14,1)*24 >= 6)
The term MOD(D14-B14,1) handles the case where the start time (B14) is one day and the end time (D14) is the next day ("runs past midnight"). Note: if D14-B14 is zero, that will be interpreted as zero time, not 24 hours.
|