use the current time to return a value

[JE McGimpsey]

One way:

G1: =IF(OR(MOD(NOW(),1)<7/24,MOD(NOW(),1)>=23/24), 3,
IF(MOD(NOW(),1)>=15/24, 2, 1))

 

[sjd371]

Simple formula? if the time is >=07:00:00<15:00:00, G$1. = 1 if time

=15:00:00 < 23:00:00 G$1 = 2 if Time >=23:00:00 < 07:00:00 G$1 = 3

I have tried to do this a few different ways and have been
unsuccessful. Could someone help please?

 

[Dave Peterson]

I think you want something like:

=IF(MOD(NOW(),1)<TIME(7,0,0),3,
IF(MOD(NOW(),1)<TIME(15,0,0),1,
IF(MOD(NOW(),1)<TIME(23,0,0),2,1)))

All one cell--G$1

 

[Dave Peterson]

Did you go back in time to test this?

(your clock/date is off)

 

[JE McGimpsey]

Yep - I didn't notice I'd failed to reset until after I'd posted a
couple more...<sigh>.

 

[Dave Peterson]

Welcome back from the past!

Yep - I didn't notice I'd failed to reset until after I'd posted a
couple more...<sigh>.