Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 25 Nov 2024 02:55:20 +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: 4120
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"))