If statement with time.

Question

I'm trying to have a cell that will add text based on what time it is currently. The Nested statement that I have does not put in the text.

I have A cell set to Now()

I have Cell B with the value of 7am, Cell C has the value of 8am.

The If statement would be: If Now() is less than 7 text is new cell will say "Low". Then if Now() is between 7 and 8 text will say "Med". Then if Now() is more than 8 text will say "High".

This is what I have:

=IF(B1<A1,"LOW",IF(AND(B1>A1,C1<A1),"Med",IF(C1>A1,"High","")))

hansvogelaar · Answer

Nefe1930&nbsp;
Try
&nbsp;
=LET(t, MOD(NOW(),1), IF(t&lt;D75, "Low", IF(t&gt;E75, "High", "Med")))

hansvogelaar · Answer

roelofknol
Excel stores dates and times as numbers, with 1 day as unit. In a date/time, the integer (whole number) part of the value represents the date, and the fractional part the time.
NOW() returns the current date AND time.
MOD(NOW(), 1) removes the integer part and leaves only the fractional part, i.e. the time. We can compare this with the times in D75 and E75.

sergeibaklan · Answer

Nefe1930&nbsp;
As variant
=IF( MEDIAN($B$1:$C$1, NOW() ) = $B$1,  "Low",
 IF( MEDIAN($B$1:$C$1, NOW() ) = NOW(), "Med",
 IF( MEDIAN($B$1:$C$1, NOW() ) = $C$1,  "High"
)))

nefe1930 · Answer

SergeiBaklan&nbsp;ok here is what is going on. The current time is 2:19pmThe if statement is =IF( MEDIAN($D$75:$E$75, NOW() ) =$D$75, "Low",IF( MEDIAN($D$75:$E$75, NOW() ) = NOW(), "Med",IF( MEDIAN($D$75:E$75, NOW() ) = $E$75, "High")))&nbsp;This is what I'm getting&nbsp;&nbsp;

nefe1930 · Answer

That worked!! thanks

Forum Discussion

If statement with time.

Share

Resources