Seconds2Time

Converts seconds from numbers into time in format of
Days:Hours:Minutes:Seconds (dd:hh:mm:ss)

Function Seconds2Time(TotalSeconds)
 Seconds1 = TotalSeconds Mod 60
 Minutes1 = TotalSeconds \ 60 Mod 60
 Hours1 = TotalSeconds \ 3600 Mod 24
 Days1 = TotalSeconds \ 3600 \ 24
 Seconds2Time = Days1 & ":" & Hours1 & ":" & Minutes1 & ":" & Seconds1 ' & " seconds"
End Function

TotalSeconds

Views 582 Downloads 147

'Time', 'Seconds', 'hours', 'days', 'minutes', 'Convert', 'Replace', 'Change', 'NotMyWork'

ANmarAmdeen
324
Date+Time Classic ASP
Revisions

v1.0