What function to use to turn seconds -> minutes

Hi all,

I have a data item that returns timestamps, but in exact seconds format. For example, it will say
Sentence 1 start time: 92.304
Sentence 2 end time: 95.395

What function do I use to turn this into the minutes & seconds (approximated)? For example the function should turn it into:

Sentence 1 start time: 1:53
Sentence 2 end time: 1:59

Hi @rambizn

Achievable using the β€œget” and β€œsplit” functions.

Please try with the below formula

{{replace(((get(split(92.304; β€œ.”); 1)) / 60); β€œ.”; β€œ:”)}}

Input:
image

Output:
image

MSquare Support
Visit us here
Youtube Channel

3 Likes

Amazing job, thank you so much my friend

2 Likes