Im using

A9 = A10 - (5/1440) copied up to create the 5 minute time difference between rows

A10=FLOOR(NOW(),5/1440) to create the interval that only updates every 5 minutes

but how does one calculate the time difference, maybe as a percentage, between A10=FLOOR(NOW(),5/1440) and =NOW()

Thanks