Solved If formula on time frame

February 17, 2015 at 14:33:33
Specs: Windows 7
I have time in this format 24:49:01
and I want to apply if condition that if time is in between 0-2 hrs its shows A and if time is in between 2-4 hrs it show B and if time is 4hrs above then it show C.

See More: If formula on time frame

Report •

#1
February 17, 2015 at 16:16:14
✔ Best Answer
Try this and see if works for you:

With your Time in cell A1 in cell B1 enter the formula:

=IF(A1="","",IF(HOUR(A1)<=2,"A",IF(HOUR(A1)<=4,"B","C")))


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question