Convertime a decimal time figure into a true time figure

[SDS100UK]

Hi,

Does anyone know the formula that converts decimal time into true time?
i.e. 2.5 hrs (dec) = 2:30 (true time)

I would appreciate your help with this , otherwise I will have to struggle to write it myself.

Thanks in advance

Steven

 

[VogonPoet]

Assuming the output can be a string, you could use the following function:

Public Function TrueTime(DecTime As Double) As String
Dim intTime As Integer
Dim dblMinutes As Double

intTime = Int(DecTime)
dblMinutes = DecTime - intTime

TrueTime = Format$(intTime, "0&quot & ":" & Format$(dblMinutes * 60, "00&quot

End Function

 

[MichaelRed]

? format(2.5/24, "Short Time&quot
02:30


Hint the hint is in the denominator!

Another Hint. DO NOT try this at home with Numerator > Denominator.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over