Help

Formula time help

1377 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nga_Ptt
4 - Data Explorer
4 - Data Explorer

Fomular If or whatever
from 11pm to 7.59am > Yes
from 8 am to 10.59pm > No

Thanks

2 Replies 2

How are your time-stamp fields defined? Text? Date?

If the latter, in the first example — 11pm to 7.59am — are you checking for whether the tested value falls within a specific 9-hour block (say, from 11pm yesterday to 7.59am today) or just whether it is later than 11pm and earlier than 8am?

Nga_Ptt
4 - Data Explorer
4 - Data Explorer

image
It’s Date, Include time field and Time Fomat Is 12 hour
I Simple Want to know if it is later than 11pm and earlier than 8am and back
Thank you so much
T^T