better way to convert seconds into dd:hh:mm:ss?
right now i have
Code:
'Start time conversion
If Secs > 60 Then
Do
Secs = Secs - 60
Mins = Mins + 1
Loop Until Secs < 60
End If
If Mins > 60 Then
Do
Mins = Mins - 60
Hours = Hours + 1
Loop Until Mins < 60
End If
If Hours > 24 Then
Do
Hours = Hours - 24
Days = Days + 1
Loop Until Hours < 24
End If
and i don't think it's really efficient since this will be calculated every second.
in Secs, i have a huge number, which is the difference in time between today and some time after. i'd like to convert that into "dd Days hh Hours mm Minutes ss Seconds" without being as inefficient as what i have above. i could just format it as "dd:hh:mm:ss" but i'd like to have "Days Hours Minutes, and Seconds" though. :D