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

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

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.

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