how to get "day/night" from a cell of time/hour

kbee · Feb 13, 2008

cell a1=1/1/08 08:00:00 AM, cell a2= 1/1/08 22:00:00 PM
cell b1 or b2= day/night
what should be the syntax?
thanks to anyone who can help with this.

T. Valko · Feb 13, 2008

You need to define when day ends and night begins and when night ends and
day begins.

Tyro · Feb 13, 2008

You also need to stop asking the same question multiple times in the
newsgroups.

Tyro

T. Valko · Feb 13, 2008

You need to define when day ends and night begins and when night ends and

day begins

Or, are you simply going by AM/PM ?

Work Hours	1	Jan 30, 2008
Hours between to two times	3	Oct 15, 2008
Conditional Time Calculation	10	Apr 8, 2013
Calculate elapsed time excluding specific timeframe	10	Mar 13, 2013
separating date and time	5	Apr 24, 2013
Calculate the time difference excluding weekends and out of businesshours ( i.e. 8AM - 5 PM)	3	Jul 28, 2008
how do I calculate a week days hours with the 24hour clock	5	Jun 28, 2009
Convert times to text string	3	Apr 21, 2010

Ask a Question