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 hour 30 minutes as 01:30, not as 1.5 or 01:30:00

[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 am running into an issue with my time calculation. We are calculating a duration (End Time - Start Time) and the Math Column is displaying the results in HH:MM:SS format when we are needing it in HH.MM format. For example, if the start time was 6:00 am and the end time was 7:30 am that would calculate to 01 hour and 30 minutes. We need this to display at 1.5 hours, but glide is displaying the results as 01:30:00. How can I change this? I changed the formula to ((End Time - Start Tim…

[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 need to format that for display as hh:mm. So, for example… 2914 => 48:34 804 => 13:24 63 => 01:03 5 => 00:05 0 => blank As far as I could tell, none of the plugin columns will handle this. But it looks easy, right? Well, the best I could do with Glide computed columns was 6 (!!) …

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 minute values, then a template column to join it back together. Might intially need a template column to lock the duration as a string before either method. Also another method would be to use some mildly complex math to end up with 8.44 instead of 8:44:00, then replace ‘.’ with ‘:’ Maybe I should ask…do you only need the duration to be a string or does it have to be a number for further calculations?

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:MM:SS column would have shown the duration as 00:09:50, instead it just shows up as 9:50. which invalidates our theory. [HH MM split text] [Slice array]

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	5	1499	March 28, 2022
How to format seconds to duration HH:MM Ask for Help	6	932	October 4, 2022
Format duration in minutes as hh:mm Ask for Help custom-code	8	1330	December 29, 2021
Time duration not presenting correctly in glide chart ⏱ Ask for Help	8	1982	March 10, 2021
Convert time Ask for Help	2	71	October 22, 2024

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

Related topics