Time Conversion Seconds (SS) to MM:SS
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm trying to convert Seconds to Minutes and Seconds.
I'm having trouble that when there are Hours (HH) that gets added or dropped....
So 60 Sec should be 01:00
6000 seconds should be 100:00 and not 01:40:00
Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Don’t have my laptop to hand but give the following a try. Can check when home if this doesn’t work and nobody else has jumped in!
DateTimeFormat(DateTimeParse([Insert your field], ‘%S’), ‘%M:%S’)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
May need to convert your field containing seconds to a string first for the function to work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The Time Datatype always saves it like you described it. If you want to save it differently you might want to change your datatype to be an integer. With "DateTimeMinutes" you will then get the absolut number of Minutes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks!! Much appreciated.
