General discussion
January 19, 2004 at 07:15 AM
antonjou

Excel2000 data entry for time in seconds

by antonjou . Updated 22 years, 8 months ago

How do I enter stopwatch laptime in Excel cells, keeping seconds and minutes apart i.e. the following example:

My Stopwatch readout time was 1 minute 45 secs.
I want to enter it in an Excel cell as 1 and 45;
NOT as 1,75 or 1+ 0.75 or any decimal notion;
I want the seconds and minutes in the same cells in order to sort between different athletes

This discussion is locked

All Comments