fixed time being offset from location by 1 row