What formula in macro can I use to show a value as dd:hh:mm, exceeding 31 days?

Question

When using the format for dd:hh:mm Excel gives us, it is not possible to show an amount of days greater than 31.

Using the following formula in macro is not possible

=INT(C5)&":"&TEXT(C5,"hh:mm:ss")

Does anyone know a way to translate a number to dd:hh:mm using a VBA macro?

Answer 1

Im not quite sure what it is you are after but I think what you were looking for is the Format function?

Sub Test()

Dim C5As Double: C5= 44.509201
Debug.Print Int(C5) & ":" & Format(C5, "hh:mm")

End Sub