Hi. I calculated the time between my date using End - Start formula. The result is coming in as HH:MM:SS but I need to get rid of the seconds and just keep HH:MM. How do I do that? [Hours calculation] I don’t want to see Hours or minutes in decimals. I want to see the actual time taken. Like 1 …

[Screen Shot 2022-10-08 at 9.58.39 AM] just don’t use it for other calculations in the app… only for displaying

Just by the way my answer isn’t in this thread as the formula in this thread converts the time to decimals which I don’t. I just want to get rid of Seconds and keep the HH:MM format as it is. :slight_smile: [image] Change Duration Format from HH:MM:SS to HH.MM Hello, I …

[image] Format duration in minutes as hh:mm Ask for Help This is a classic example of where a single experimental code column can save you a bunch of Glide computed columns. My use case: I have a column where the value in each row represents a duration in minutes, and I …

Thanks for sharing that so quick. This is what I have got using your code. [Experimental code hours]

For simplicity, I’d probably pass it into a javascript column, split the value on ‘:’ and then rejoin only the first two parts of the array. To do it with glide columns, you could create a Split Text column to split each part into an array. Create two single value columns to get the hour and minut…

It has to be used for Donut Chart to calculate how much time in HH:MM I have spent on any activity. So on the center it should show the total HH:MM I have spent, and in the legend it should show how much I have spent on each activity.

I tried using Split Text column, separated the values by ‘:’ Used Slice Array to just get HH:MM and get rid of :SS. Now the problem is, if the duration is 9 minutes 50 seconds lets say like shown in the screenshot in the last entry, the HH doesn’t show up at all. This would have worked if the HH:M…

glide has a great time conversion column… and an Excel formulas column… use it…

I’m at my computer now, so I’ll play with this a little bit. Do you need to add several durations together, or is your graph only showing one duration per row?

I need exactly like this, just have to get rid of seconds. And I don’t need the Hours in decimals since 1.9 hours would be confusing for the users. They need to see it in the HH:MM format :slight_smile: [graph]

@Uzo , if you could suggest a solution to this that would be awesome…

How to convert HH:MM:SS to just HH:MM?

Ask for Help

Darren_Murphy October 7, 2022, 7:28pm 3

Topic		Replies	Views
Change Duration Format from HH:MM:SS to HH.MM Ask for Help	6	1440	March 29, 2022
How to format seconds to duration HH:MM Ask for Help	7	894	October 4, 2022
Format duration in minutes as hh:mm Ask for Help custom-code	8	1269	December 29, 2021
Time duration not presenting correctly in glide chart ⏱ Ask for Help	9	1942	January 17, 2024
Convert time Ask for Help	2	54	October 22, 2024

How to convert HH:MM:SS to just HH:MM?

Related topics