What function to use to turn seconds -> minutes

Questions & Answers
1

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

2

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

2 Likes
3

Amazing job, thank you so much my friend

4