Forum Discussion
Solved
Value Based on time range
Hi there, please help have trivial rutine problem need to define shift number based on time range where: first shift duration from 7:00 to 15:30 second shift duration from 15:30 to 24:00 third shi...
Wirestat , Create a new column like
Switch(true(),
timevalue([Datetime]) < time(7,0,0) , "Third Shift",
timevalue([Datetime]) < time(15,30,0) , "First Shift",
"Second Shift"
)
Wirestat , Create a new column like
Switch(true(),
timevalue([Datetime]) < time(7,0,0) , "Third Shift",
timevalue([Datetime]) < time(15,30,0) , "First Shift",
"Second Shift"
)
Thank you, How exactly this fuction works?
Also interested what if some cell have missing data?