Arvi,

I loved your solution, but it does not answer the OP's question.
It only gives an interval duration

Cheers,
--
AP

"Arvi Laanemets" a écrit dans le message de news:
...
Hi

=EndTime-StartTime+(AndTime<StartTime)

Replace EndTime/StartTime with cell references to times in valid time
format. (The wormula works when time difference remains less than 24
hours)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"RamOst" wrote in message
...
I'm setting up a shift roster and need to determine whether a given time
is
between the start time and end time of a shift where the shift runs
across 2
calendar days
eg start 23:00 finish 06:00

would appreciate any help - it's driving me mad