ExcelBanter - Time Q

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time Q (https://www.excelbanter.com/excel-worksheet-functions/217113-time-q.html)

Seanie

Time Q

How could I construct a formula that says:- IF the Time NOW is 18:00
but < 24:00, carry out formula A, if Not then carry out Formula B?

What I can't get my head around is extracting the time element from
the NOW() function (and not the date.

Rick Rothstein

Time Q

Either of these will give you the current "Now" time...

=NOW()-TODAY()

=MOD(NOW(),1)

--
Rick (MVP - Excel)

"Seanie" wrote in message
...
How could I construct a formula that says:- IF the Time NOW is 18:00
but < 24:00, carry out formula A, if Not then carry out Formula B?

What I can't get my head around is extracting the time element from
the NOW() function (and not the date.

Seanie

Time Q

Thanks Rick

All times are GMT +1. The time now is 05:51 PM.