Km per hour -> how many hours 1

[flaviooooo]

Hey,

if I have a value number of kilometers, and a value kilometers/hour... how can I calculate and display the number of hours, minutes and seconds (even thousands of seconds if possible)?

So I have 50 kilometers, we have a speed of 20 km/hour ->
2,5 = 2:30:0000)

Thanks in advance

 

[SkipVought]

Hi,

Convert hours to days and use the Format function to return hh:mm:ss

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[flaviooooo]

So easy

Have a star on me...

Btw: is there a "code" for a step further then seconds (what is it, milliseconds?) ?

 

[SkipVought]

You would have to handle the conversion in code, starting with whole hours and taking the remainder and converting hours to minutes, taking whole minutes and taking the remainder and converting from minutes to seconds....

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[PHV]

what is the precision of the kilometers/hour values ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[flaviooooo]

Pretty precise, here's an example:

50,0467114210129

 

[PHV]

The number of kilometers too ?

 

[flaviooooo]

Number of kilometers is an integer, so for example 53

 

[PHV]

Really ?
So, I wonder why the milliseconds are so important ...

 

[flaviooooo]

They're not so important, just a nice to have ;-)

 

[MichaelRed]

To really look at the root of the issue, you should search these foa (and FAQs) for time base calculations. You would eventually find that date/time is simply a floating point number. In the schema, the whole number part is the number of days since Dec. 30, 1898 and decimal part of the value is the "percent" of the day left over. There are 86400 seconds in a day. The remainder is simple math, with the caveat that the various date-time intrinsic function cannot (will not?) return values smaller that one second, so to see any further resoloution you need to create custom procedures.



MichaelRed