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
Bookmarks