Thread: Time Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seanie Seanie is offline
external usenet poster
 
Posts: 202
Default 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.