Calculate decimal seconds

users
#1

Hi,

I have a spreadsheet containing timing results which are displayed using the a Format code of MM:SS.00 (02:58.03).

What I require is the number of seconds the cell represents as a decimal number of seconds (178.03) for the above value.

I would be very grateful if someone point me in the right direction.

Thanks,

Vytas

#2

Helo Vytas,

I have a spreadsheet containing timing results which are displayed
using the a Format code of MM:SS.00 (02:58.03).

What I require is the number of seconds the cell represents as a
decimal number of seconds (178.03) for the above value.

Changing the format to
[SS].00
wold help.

Regards

Robert
- --
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3

#3

​The actual, numerical value stored in such a cell is a number of day. To
find this out, you can remove formating.

Suppose you have 02:58.03 in A1, you put "=A1" in A2, then Ctrl+M to remove
formatting, it will show you something like 0.002060532
To convert from "number of day" to "number of seconds", multiply with
60*60*24. For example, putting "=A1*60*60*24" in A3 will display 178.03

#4

Hi.
2 interesting options, which one you choose depends upon what you want to do with the number you get. You need to bear in mind that option 2 is just showing you DAYS in a different format.

If the time is how long to run 100 (m/ft) and you want to calculate a speed for instance you would divide 100 by the seconds.
Option 1 will give you the m(ft)/second velocity.
Option 2 will give you the m(ft)/day velocity.

Quite different answers.
Steve

I have a spreadsheet containing timing results which are displayed using
the a Format code of MM:SS.00 (02:58.03).

What I require is the number of seconds the cell represents as a decimal
number of seconds (178.03) for the above value.

Option 1

​The actual, numerical value stored in such a cell is a number of day. To
find this out, you can remove formating.

Suppose you have 02:58.03 in A1, you put "=A1" in A2, then Ctrl+M to remove
formatting, it will show you something like 0.002060532
To convert from "number of day" to "number of seconds", multiply with
60*60*24. For example, putting "=A1*60*60*24" in A3 will display 178.03

Option 2

#5

Hi Steve,

For my application using the [SS].00 option did the trick. As I required to determine number of seconds required to move 500m. I also need to sum up the resultant column.

Thanks for all the help both on-line and off-line.

Vytas