![]() To convert back from decimal seconds to MM:SS.00 cut an paste the following in Cell A3: Which will convert the contents of Cell A1 from text in ‘MM:SS.00 format to decimal seconds In Cell A2 cut an paste the following excel formula: Here is an example: In Cell A1 enter 2 min 45 seconds 30 hundredths, do this by typing ‘2:45.30 (the leading ‘ tells excel it is text). Then to do any maths and convert back to MM:SS.00 to display.įor example 2 mins 45 seconds 30 hundredths becomes 165.30 decimal seconds, excel understands decimal numbers and can easily add, subtract, compare and manipulate them □ This is really frustrating.Ĭurrently my best tip here is to enter the MM:SS.00 times as text, use an excel formula to convert the text to decimal seconds. However as soon as you click on a time using this format to edit it, it looses the hundredths! This is not great when you have carefully typed in a load of times to work with and excel promptly corrupts them □. If you search the internet you will find loads of posts saying you can enter a MM:SS.00 time in excel using the custom number format: ![]() ![]() One thing it should be good at is calculating times, however in swimming we tend to use times in the format minutes:seconds.hundredths and Excel does not really work well with times in this format. Excel is an amazing tool and is used and abused to perform many tasks it was not originally intended for.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |