Time in Minutes and Seconds

R

Ron P

How can I display Time in minutes and seconds only. What I need is the
ability to display hh:mm:ss in only mm:ss, this means that the hour needs to
be converted to minutes. I'm not sure how to go about doing this. Any
assistance would be appreciated. thanks
 
K

Ken Snell [MVP]

Format(Hour([TimeField])*60 + Minute([TimeField]),"00:") &
Format(Second([TimeField]),"00")
 

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

Converting Seconds to Hours, Minutes, Seconds 3
Slow when "Mark all as read" 3
Slow mark all as read 0
Problem with SET & REF function 0
Time Addition 2
a control for time 0
Working on birthday "book" for my wife and having layout/editing trouble 0
Mis-performing MP4 files in Mac PPT 1

Top