Hi All,
So my title description may be a little confusing but let me clarify. I have a series of elapsed times that have been recorded with a decimal seperating minutes and second (ie; 5 minutes and 10 seconds = 5.10). These lap times are recorded in the same format over approximately half an hour. I have a start time (ie; 7:27:30 AM) and I wish to determine the actual time based on the elapsed time after the start time for each lap such that...
Start Time Lap Actual Time 7:27:30 AM 2.35 7:30:05 AM 4.27 7:31:57 AM 5.10 7:32:30 AM
Notice how the last time is incorrect! This should read 7:32:40 AM. Assuming that the table above spans A1:C4 I have the following formula entered in C2 and dragged down to determine Actual time;
Formula:Please Login or Register to view this content.
Unfortunately this formula, even tho the lap time cells are formated to always show 2 digits, reads 5.10 as 5.1 and thus only adds one second instead of 10 seconds. Likewise if I have 5.00 a similar problem occurs. Unfortunately I cannot change the format of the raw lap times. I have also tried;
Formula:Please Login or Register to view this content.
But this also returns errors.
Any Ideas??? Im sure this is a simple fix. Thankyou in advance to anyone that helps
Kind regards,
Ben
Bookmarks