Forum Discussion

Rik_JAc's avatar
Rik_JAc
Copper Contributor
Jun 08, 2023
Solved

check if a time falls between a time range (crossing date lines)

  I am currently trying to create a spreadsheet for a rostering system where I will insert a start time and an end time for employees and then the spreadsheet will insert a value to indicate they ar...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 08, 2023

    Rik_JAc 

    That could be

    with

    =IF( MEDIAN($D$2,$D$2+MOD($D$3-$D$2,1),$C4) = $C4, " O", ""  )
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 08, 2023

Rik_JAc 

That could be

with

=IF( MEDIAN($D$2,$D$2+MOD($D$3-$D$2,1),$C4) = $C4, " O", ""  )
  • Rik_JAc's avatar
    Rik_JAc
    Copper Contributor
    Jun 08, 2023
    Initial tests look good.

    Thank you so much for your help.

Resources