hi team,
for the life of me i can't seem to work out a true or false for between work hours.. i've googled and seen responses, however cant seem to make it work.
My sheet is converting epoch time to 24h time;
epoch; 1662370201918
converted; =epoch/86400000+DATE(1970,1,1)
returning = 05/09/22 09:30:02
I'm wanting a true if the time is between 8:00 and 18:00
thanks
for the life of me i can't seem to work out a true or false for between work hours.. i've googled and seen responses, however cant seem to make it work.
My sheet is converting epoch time to 24h time;
epoch; 1662370201918
converted; =epoch/86400000+DATE(1970,1,1)
returning = 05/09/22 09:30:02
I'm wanting a true if the time is between 8:00 and 18:00
thanks