Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 28 Apr 2024 16:50:45 +0000

How to Post a Message for Support

Post From: Time in spreadsheets

[2013-12-30 05:02:07]
[Go To First Post]
Sawtooth - Posts: 3980
Use the TIMEVALUE function, like this in J29:

=J41-INT(J41)>TIMEVALUE("15:59:00")

or this in J28:

=OR(J41-INT(J41)<TIMEVALUE("09:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00"))