Sorry about the newbie question, but I've tried using the online help and can't figure it out.
A cycle club I belong to had a time trial race. We start the stop watch at 0:00 and riders went off at 30 second intervals then do several laps of a course and then finish. We recorded lap times and finish times all from the reference starting time (00:00).
I want to make a spreadsheet that I can enter each start time in minutes and seconds starting at 00:00. I imagine this would be column 1 and go in sequence 00:00, 00:30, 1:00 etc etc. But I don't seem to be able to set the format that shows the number as a time that isn't the time of day. When I type in 00:00 excel sees it as 12:00am.
From there I want to be able to enter all the data from the laps and finish times in seperate columns then use simple formulas to subtract the recorded time from the start sequence (30 second intervals) to get the actual lap times and finish time.
Every thing I do tends to become a problem because of excel seeing the time as a time of day rather than a elapsed time from the 00:00 start time.
Help please.
Bookmarks