Search code examples
excelvbaformula-editor

Convert time range to a text value

I have a table in excel that has a column with times in it hh:mm:ss I want to convert it so that anything from: 08:00:00 to 17:59:59 is the text value D 18:00:00 to 23:59:59 is the text value E 00:00:00 to 07:59:59 is the text value N

I am having issues doing this and wondered if you could help?

Solution

  • You don't need VBA. Assuming your time value is in A2, Try this:

     =IF(HOUR(A2)>=18,"E",IF(HOUR(A2)>=8,"D","N"))