Fill cell based on time value

New to the forum and not very skilled in Excel. I need a bit of help with something that is probably very basic yet I can't figure it out.

I download a report that shows a completion time of all "jobs" in date/time format ex: 6/25/2012 18:45. The jobs are completed 24/7 so I need to define if they were completed on Day shift (5:00 to 16:59) or Night shift (17:00 to 4:59) by adding a value of "A" for Day shift and "B" for Night shift in a new cell.

Any help is greatly appreciated.

Hi
try this formula
=IF(MOD(A1,1)<5/24,"B",IF(MOD(A1,1)>=17/24,"B","A"))

That did it!

Thank you!

Alternative

=IF(OR(HOUR(A1)<5,HOUR(A1)>=17),"B","A")

Please remember to mark your thread as SOLVED (instructions in rule #9 - click Forum Rules @ top of page to view).