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