![]() Now, notice in the full formula that each of the items in the list above are added + together. Item two works on the next number 02, converting it to minutes. VALUE(3600*LEFT(A1,2)) is converting 00, the hours place, to seconds. Each of those four numbers corresponds to the four parts above, from left to right. ![]() Looking at the string 00:02:02.300, you can see it is basically four numbers separated by : and. It is looking at the cell A1 as a text string, then converts parts of it to numbers, then adds them together appropriately to make them into total seconds. ![]() To get trailing zeros, format B1 as a number and adjust to your tastes. It will display something that looks like nonsense. The trick is easy to get seconds and miliseconds only, that is 122.300.įirst, assume 00:02:02.300 is in cell A1. If you have 00:02:02.300 in a cell, it may appear exactly like this if it's formatted as text 1, or it may appear differently if it's formatted like something else.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |