Conditional maybe IF question
 

Hey, how you doing everybody!
In the F1 cell I have =NOW() with cell format *1:30:55 PM . Is it possible
this cell or a different cell with IF can show (display) me somehow "morning"
, "afternoon" , "evening" etc.
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt

Conditional maybe IF question
 

I am not sure how 'evening' is defined but MOD(F1,1) returns the time as a
fraction of a day.
I chose 6:00 PM as start of evening and used
=IF(MOD(F1,1)<0.5,"Morning",IF(MOD(F1,1)<0.75,"Aft ernoon","Evening"))
or
=IF(MOD(F1,1)<TIME(12,0,0),"Morning",IF(MOD(F1,1)< TIME(18,0,0),"Afternoon","Evening"))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Zsolt Szabó" wrote in message
...
Hey, how you doing everybody!
In the F1 cell I have =NOW() with cell format *1:30:55 PM . Is it possible
this cell or a different cell with IF can show (display) me somehow
"morning"
, "afternoon" , "evening" etc.
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt

Conditional maybe IF question
 

Zsolt

It is possible but..........

Define the time ranges for morning, afternoon and evening.


Gord Dibben MS Excel MVP

On Sun, 10 Dec 2006 12:28:01 -0800, Zsolt Szabó
wrote:

Hey, how you doing everybody!
In the F1 cell I have =NOW() with cell format *1:30:55 PM . Is it possible
this cell or a different cell with IF can show (display) me somehow "morning"
, "afternoon" , "evening" etc.

Conditional maybe IF question
 

Zsolt

Depends when you see evening starting, but this takes <=midday=morning,
<=4:00pm=Afternoon, after 4:00pm = evening

=IF(MOD(NOW(),1)<=0.5,"Morning",IF(MOD(NOW(),1)<=0 .6666666,"Afternoon","Evening"))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Zsolt Szabó" wrote in message
...
Hey, how you doing everybody!
In the F1 cell I have =NOW() with cell format *1:30:55 PM . Is it possible
this cell or a different cell with IF can show (display) me somehow
"morning"
, "afternoon" , "evening" etc.
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt