J
John Calder
Hi
I run Excel 2K
I have a series of times that I download from the mainframe. (these are in a
date format)
EXAMPLE
23/09/2009 6:07:00 AM
22/09/2009 9:22:00 PM
22/09/2009 7:40:00 PM
etc etc
I am in need of a formula that looks at these times, and based on their
values, displays a particular piece of text. (in this case "DAY", "AFT",
"NIGHT")
Example
Any time between the following:
7:20:00 AM to 3:19:00 PM should display the word DAY
Any time between the following:
3:20:00 PM to 11:19:00PM should display the word AFT
Any time between the following:
11:20:00 PM to 7:19:00 AM should display the word NIGHT
Assume the original time is in cell B8
Thanks
John
I run Excel 2K
I have a series of times that I download from the mainframe. (these are in a
date format)
EXAMPLE
23/09/2009 6:07:00 AM
22/09/2009 9:22:00 PM
22/09/2009 7:40:00 PM
etc etc
I am in need of a formula that looks at these times, and based on their
values, displays a particular piece of text. (in this case "DAY", "AFT",
"NIGHT")
Example
Any time between the following:
7:20:00 AM to 3:19:00 PM should display the word DAY
Any time between the following:
3:20:00 PM to 11:19:00PM should display the word AFT
Any time between the following:
11:20:00 PM to 7:19:00 AM should display the word NIGHT
Assume the original time is in cell B8
Thanks
John