Skip to main content

Formula time help

  • December 14, 2018
  • 2 replies
  • 31 views

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

Thanks

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+5
  • Inspiring
  • December 15, 2018

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?


  • Author
  • New Participant
  • December 17, 2018


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