How to group time conditionally?

[xlmaniac]

Dear All,
I need to populate remarks based on the following time.
Time samples are in Column A
Desired results would be in Column B

22:01:36(A1) should be < 24 hours (B1)
36:19:56(A2) should be >24-<48 hours (B2)
54:30:45(A3) should be >48 hours
Pls help with the formulae in Column B which can yield the desired remarks as shown above.
Thanks

 

[etaf]

what do you want if the time is = 48 or -=24
you only say < 24 or > 24

try
=IF(A1<1,"< 24 hours",IF(A1<2,">24-<48 hours",">48 hours"))
this will Include 24:00 as ">24-<48 hours" and 48 hours as ">48 hours"

Book8
	A	B
1	22:01:36	< 24 hours
2	36:19:56	>24-<48 hours
3	54:30:45	>48 hours
4	48:00:00	>48 hours
5	24:00:00	>24-<48 hours
Sheet1

Cell Formulas
Range	Formula
B1:B5	B1	=IF(A1<1,"< 24 hours",IF(A1<2,">24-<48 hours",">48 hours"))

otherwise include an equals =

Book8
	A	B
1	22:01:36	< 24 hours
2	36:19:56	>24-<48 hours
3	54:30:45	>48 hours
4	48:00:00	>24-<48 hours
5	24:00:00	< 24 hours
Sheet1

Cell Formulas
Range	Formula
B1:B5	B1	=IF(A1<=1,"< 24 hours",IF(A1<=2,">24-<48 hours",">48 hours"))

 

[xlmaniac]

what do you want if the time is = 48 or -=24
you only say < 24 or > 24

try
=IF(A1<1,"< 24 hours",IF(A1<2,">24-<48 hours",">48 hours"))
this will Include 24:00 as ">24-<48 hours" and 48 hours as ">48 hours"

Book8
	A	B
1	22:01:36	< 24 hours
2	36:19:56	>24-<48 hours
3	54:30:45	>48 hours
4	48:00:00	>48 hours
5	24:00:00	>24-<48 hours
Sheet1

Cell Formulas
Range	Formula
B1:B5	B1	=IF(A1<1,"< 24 hours",IF(A1<2,">24-<48 hours",">48 hours"))

otherwise include an equals =

Book8
	A	B
1	22:01:36	< 24 hours
2	36:19:56	>24-<48 hours
3	54:30:45	>48 hours
4	48:00:00	>24-<48 hours
5	24:00:00	< 24 hours
Sheet1

Cell Formulas
Range	Formula
B1:B5	B1	=IF(A1<=1,"< 24 hours",IF(A1<=2,">24-<48 hours",">48 hours"))

Thank you so much for your help.
Really appreciate

 

[etaf]

you are welcome