formula Help

[smartguy]

Hello All,

I Have Excel File in the below Format.

Excel Workbook
	A
1	Time
2	23:25:42
3	4:00:00
4	1:00:00
Sheet1

If time <= 3:00:00 Then I need Answer in B Column States <3 Hours else > 3 Hours.

Please Help !!1

 

[Jonmo1]

Try

=IF(A2-INT(A2)<"03:00:00"+0,"<3 Hours",">3 Hours")

 

[prabby25101981]

=if(hour(a2)<3,"<3",">=3")

 

[Fowmy]

May be:

=IF(A2<=TIMEVALUE("3:00:00"),"<3",">3")

 

[smartguy]

If time is More than 24 Hours it's Not Working....

 

[prabby25101981]

Try this -

=IF(((DAY(A2)*24)+HOUR(A2))<3,"<3",">=3")

 

[Jonmo1]

OK, so the times are just cumulated times..so you might have say 25:00:00
YOu would want that considered as 25 hours, not 1AM ?

Then just a simple

=IF(A2<"3:00:00"+0,"<3Hours",">3Hours")


all the other fancy stuff was on the assumtion your cells were actually dateANDtime