How to categorize time into Day/Night?

		Microsoft Office Forums > Microsoft Excel > Excel
How to categorize time into Day/Night?

12-23-2017, 12:56 PM

Logit

Windows 10 How to categorize time into Day/Night?

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

.
Assuming your time data begins in F2 :

Code:

=IF(AND(F2>=TIMEVALUE("6:00:00"))*(F2<=TIMEVALUE("19:00:00")),"Day","Night")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Maximum Categorize shortcuts in Outlook 2010?	King Mustard	Outlook	0	11-20-2017 04:13 AM
Calculate time from midnight on (Weekend hours, Fri-Sat night shift problem)	stormrider2230	Excel	1	01-20-2016 01:41 PM
Can we categorize and filter texts in Microsoft Word	AAl-mutahr	Word VBA	1	09-01-2014 07:15 AM
categorize gone!	paascal	Outlook	3	07-26-2012 03:17 PM
Best practice to categorize my tasks?	LoveOffice	Project	0	03-08-2010 01:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:23 AM.