Time in Minutes and Seconds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Format(Hour([TimeField])*60 + Minute([TimeField]),"00:") &
Format(Second([TimeField]),"00")
 
Back
Top