IF function using time

L

Lorrie

Well - I'm having a little trouble.

I'm using this IF function but it doesn't work:

=IF(I9=>"7:30","7:30",I9)

If the cell I9 has a SUM of 12:30, this formula results
in a 12:30 entry. What I need is if I9 is equal to or
greater then 7:30 then I need 7:30 entered. If it is
less then 7:30, I need the results of I9 entered, which,
as an example, might be 4:30.

I know that entering formulas with time can be difficult
and no matter what I try - I can get this.

Thank you for your help.

Lorrie
 
P

Peo Sjoblom

A couple of ways

=IF(I9>=--"07:30",--"07:30",I9)

or

=IF(I9>=TIME(7,30,),TIME(7,30,),I9)

format as time
 
Top