View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RamOst
 
Posts: n/a
Default Time between days

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