An easy one?! Speed-Distance-Time.

[topster]

An example:
Distance (8 kilometers) / Speed (100 km/h) * 3600 = Time (288 seconds)

But when I format the Time-cell for mm:ss I just get 00:00.
How do I get the Time to show as 4:48?

Thanks
/T

 

[Gerald Higgins]

Try dividing your result by 86400 (the number of seconds in a day).

Example, if your formula is in A1

=a1/86400

and format as mm:ss or hh:mm:ss

 

[topster]

Worked!

Thanks a lot