Run an IF statement using a macro?

[helenski69]

Hello there guys and gals,

I have set up a spreadsheet that is updated weekly with my engineers time sheet details and I have setup an If statement that determines if and when each of them is late. I'm trying to figure out a way that I can use a macro that moves down a cell everytime for the start time (highlighted red) but keeps cell H1:


=IF(C2<H1, Time?, ?On p ?Late?)<> < H1, "On Time", "Late")
Is there any way of say setting up a button that will calculate all of the rows entered without me having to physically having to enter the IF statement on each row? Or would I be better off setting up a macro??

 

[Sektor]

=IF(C2 < $H$1, "On Time", "Late")

 

[helenski69]

Excellent, thanks!!!!!