by roy (2 Submissions)
Category: Math/Dates
Compatability: Visual Basic 3.0
Difficulty: Beginner
Date Added: Wed 3rd February 2021
Rating: (7 Votes)
Convert seconds to minutes with just one line of code. I was encouraged to submit this after seeing where some guy had submitted 50 or so lines of code to do the same thing. This can be expanded to return hours, just follow the logic.
Dim lSecs As Long
Dim sMin As String
lSecs = 120
sMin = Format(Fix(lSecs / 60), "#0") & _
":" & Format(lSecs Mod 60, "00")
MsgBox sMin