iwhich funvtion to use : in conversion of date and hour to day and
 

=IF(A1=TIME(18,,),"night","day")

"kbee" wrote:

I need to convert the data from a cell that contains date and time to a
different cell that will give a result of day /night, which functions should
I use and what will be their syntax?
if the hours i refere to as day are 7:00AM-18:00PM, and night 18:00Pm-07:00AM
thank you

iwhich funvtion to use : in conversion of date and hour to day and
 

It's interesting to note that with your formula, 12:01:00 AM returns Day.
Where I live in the USA, it is dark at that time. <g

Tyro

"Teethless mama" wrote in message
...
=IF(A1=TIME(18,,),"night","day")

"kbee" wrote:

I need to convert the data from a cell that contains date and time to a
different cell that will give a result of day /night, which functions
should
I use and what will be their syntax?
if the hours i refere to as day are 7:00AM-18:00PM, and night
18:00Pm-07:00AM
thank you