To check whether the hours is greater than 24 hours or not

Dear All,

I have hours and minutes in a cell and I want to check whether it is greater than 24 hours or not.

In cell A1 it is 49:27 (format of the cell is [h]:mm) and in cell B1 I need the output using a formula.

Any help appreciated.

Thanks,
aganesan99

Please try this. =if((TEXT(A1,"[h]")+(TEXT(A1,"m")/60))>24,True statement,False statement)

Originally Posted by RKXLNT

Please try this. =if((TEXT(A1,"[h]")+(TEXT(A1,"m")/60))>24,True statement,False statement)

Thanks a lot "RKXLNT". It worked.

aganesan99

Perhaps

=IF(A1>1,True statement, False statement)