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
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 6,161
Downloads 1,555
CodeID
DB ID