Time Conversion Seconds (SS) to MM:SS

[TheSAguy]

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.

[DataNath]

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’)

[DataNath]

May need to convert your field containing seconds to a string first for the function to work.

[FrederikE]

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.

[AngelosPachis · Accepted solution]

Hi @TheSAguy ,

Here's how you can do it using a formula tool

Hope that helps,

Angelos

[TheSAguy]

Thanks!! Much appreciated.