Hylton Conacher (ZR1HPC) wrote:
Hi,
I am battling to convert time to a digital value and back again via
Openoffice that my Sharp EL-532 calculator does with no problem.
I would like to be able to enter a time value as mm:ss and then be
able to calculate what the time is for a distance over a certain
distance ie I walk 3km in 31:34, what is my speed and also my min/km?
How should I format the cells and what formula will enable me to
convert the time to a digital value that can be dived, and then
re-formatted to show a mm:ss value?
You shouldn't need to do any re-formatting - the formatting of a cell as
mm.ss purely displays a human-recognisable form of the underlying
date-time number. Any calculation is done on this underlying date-time
number, NOT the "formatted" view that you see.
--
Say No to OOXML
http://www.linuxjournal.com/article/9594#mpart8
Email address not monitored - reply to group
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
