How to convert Duration "2 hrs 50 mins 57 secs" to "2:50:57"

Hi !

How to convert the duration into HH:MM:SS format?

I need Google sheet to understand the format of the duration correctly.

Thank you so much!

Hey there!

This, if not exactly what you need, should give you all you need to format your duration correctly! Check out the formulas in the Hours, Minutes, and Seconds columns

4 Likes

Hello @Scott_Collier-Weir

Your solution is really excellent and would find its place in the official documentation :slight_smile:

Sincerely,

Thierry

3 Likes

@Scott_Collier-Weir Thank you so much for your time and quick response!!! :+1: :handshake:

1 Like

@Scott_Collier-Weir , I guess you have good reasons not to add the ToTime()

Format("{1}:{2}:{3}",thisRow.Hours,thisRow.Minutes,thisRow.Seconds).ToTime()

which then results in :slight_smile:

Cheers, Christiaan

3 Likes