If Formula Based on Current Time

**Jiptastic** · 05-11-2013, 01:41 PM

Can anyone help me make this formula work? I want the formula to display 1,2, or 3 depending on the time. This is the basic logic but the syntax is all wrong.

Please Login or Register  to view this content.

**XOR LX** · 05-11-2013, 01:56 PM

=IF(NOW()<TODAY()+TIMEVALUE("10:00"),1,IF(NOW()<TODAY()+TIMEVALUE("15:00"),2,3))

Regards

**Tony Valko** · 05-11-2013, 05:03 PM

Use a cell to hold the current time.

A1: =NOW()

Format as Time h:mm

Then:

=IF(HOUR(A1)<10,1,IF(HOUR(A1)<15,2,3))

**XOR LX** · 05-11-2013, 05:10 PM

Nice, Tony. Your moniker is certainly justified by that one! And my response a little humbled!

**Tony Valko** · 05-11-2013, 05:16 PM

Thanks!

**Jiptastic** · 05-13-2013, 04:17 PM

I like both solutions. Thanks

**Tony Valko** · 05-13-2013, 04:21 PM

You're welcome!

If Formula Based on Current Time

LinkBack

Thread Tools

Rate This Thread

Display

If Formula Based on Current Time

Re: If Formula Based on Current Time

Re: If Formula Based on Current Time

Re: If Formula Based on Current Time

Re: If Formula Based on Current Time

Re: If Formula Based on Current Time

Re: If Formula Based on Current Time

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions