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

1

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!

2

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
3

Hello @Scott_Collier-Weir

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

Sincerely,

Thierry

3 Likes
4

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

1 Like
5

@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:

image
image1747×725 59.5 KB

Cheers, Christiaan

3 Likes
6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.