length minutes and seconds

B

BBran

How does one get a numeric field representing length of time in seconds, to display as length of time in minutes and seconds? In other words 244 seconds equals 4 minutes and 4 seconds (4:04).
 
D

Douglas J. Steele

So, to give a complete answer, you can write a function like:

Function ConvertToMinutesAndSeconds(TotalSeconds As Long) As String

ConvertToMinutesAndSecond = TotalSeconds \ 60 & _
":" & Format(TotalSeconds Mod 60, "00")

End Function
 
B

BBran

Thank you both very much!

So, to give a complete answer, you can write a function like:

Function ConvertToMinutesAndSeconds(TotalSeconds As Long) As String

ConvertToMinutesAndSecond = TotalSeconds \ 60 & _
":" & Format(TotalSeconds Mod 60, "00")

End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Delete text from bulleted paragraphs 1
using time data copied and pasted into excel from external source 4
Minutes and seconds 4
Paste to excel from word - auto format problem 1
Converting Seconds to Hours, Minutes, Seconds 3
Storing time as integers 6
Scroll does not show preview 0
Convert text entered as minutes/seconds to minutes 1

Top