Monday 7:30 AM 1:00 PM 2:00 PM 5:00 PM 8:30 8.50

I am looking to do an if function formula for the if this 8:30 is over 8:00 then this 8.50 should be 8.00

I cant get it to do it

Could you please post a small sample sheet showing your data and expected results ( click Go advanced Manage attachments)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Questions: I am looking to do an if function formula for the if this 8:30 is over 8:00 then this 8.50 should be 8.00

Try This:

=IF(8:30/8:00, 8:00)

You can use relative cell reference for the first argument if there are rows and columns you want to input.

Also, make sure the number type is set to time! Home tab - Number Group - drop down arrow - time