Converting milliseconds to mm:ss

[salasia]

Hi, I think there is a small bug in your Date/Time converter.
I need to convert the duration of a video in milliseconds to this format: mm:ss
But it works only starting from around 276000 ms (which is 04:36). Below that (as per my screenshot), the response is always 00:00
Could you please check and let me know if you can fix it?
Regards
Sergio

 

[Pabblymember11]

Hey @salasia

It seems like you didn't pass the timestamp in the correct format in the Date Time Formatter action step.

Timestamp with millisecond format has 13 digits on it- 1254741245896, where you have passed the time with only 6 digits.

Kindly try passing the timestamp in the correct format and try again.

 

[salasia]

Hi Supreme,

thank you for your reply. I don't need to format a proper timestamp, but the duration of a video, between 00:01 (one second) and 59:59.
I take this value from Google Drive, so for example:
5,000 ms = 5 seconds = 00:05
60,000 ms = 1 minute = 01:00
etc.

Now, after many experiments, I've realised that (for my purpose) Pabbly works only when the duration is over 4 minutes 36 seconds, otherwise it will just return 00:00.

Here for example:
600,000 ms = 10 minutes = 10:00

I was just wondering if this was something that can be fixed because it doesn't make sense that it works for higher values and it doesn't for smaller values.
Bests
Sergio

 

[Pabblymember11]

Hey @salasia

Date/Time Formatter doesn't work that way, it basically converts the date from one format to another. It doesn't convert time from milliseconds to mm: ss.

And if you want to convert the time from millisecond to minutes and seconds, you can try the mathematical formula for that.

 

[salasia]

Hi @Supreme,

apparently it does work like that, as I've tried a lot of small millisecond values and it returns the right min:sec value. But weirdly enough it doesn't work for very very small values (below ~280000 ms) but I think it should. Because it would be like converting the very early timestamps that were used just past midnight Jan 1st 1970, example:

I know I can use the math formula to convert it, but it gives me the decimal seconds, not the "0-59" seconds. So for a video that is 4 and a half minutes long, I want to see 4:30 instead of 4.50.

Thanks for your patience
Sergio