IF function using time

  • Thread starter Thread starter Lorrie
  • Start date Start date
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
 
Hi Lorrie!

Here's one way:

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

For a good reference on time, I'd recommend:

Chip Pearson:
http://www.cpearson.com/excel/datetime.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
A couple of ways

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

or

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

format as time
 
Back
Top