I have a time field in the format [HH]:MM:SS,00 which represents the length of time I’ve run so far in the week. So every day, after I’ve been for a run, I’d like to select the cell for the weekly running total and add the new time. For example if I’ve so far run for 03:29:24,00 and I’ve just come in from a run that lasted for 00:30:24,00 I’d like to be able to edit that time by just adding the new one: 03:29:24,00 + 00:30:24,00, However if I try to do this, I just get a 502 error.
Note: I am not trying to add two cells, but rather update the data in a single cell to reflect the new time spent running during the current week by adding the new amount of time.
Note also: the formula in the image above is its form after leaving the cell, so leading and trailing zeroes have been removed (tens of hours, tens of minutes and hundredths of a second).
Is there a way to do this without causing an error?