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

Thanks @Jeff_Hager for taking out time to experiment this and thanks @Darren_Murphy for the code. Quickchart was my last option since I wanted to do something native on Glide. That’s unfortunate that this can’t be done natively on Glide :frowning: But lets see what @Uzo has in his mind since he is …

I suspect that Uzo was referring to the Format Date plugin. Two points I’d make about that: It won’t help you in this case because it returns a string. And so you will be back to square one. Use it at your own risk

here you go… no problem :wink: [Screen Shot 2022-10-08 at 9.15.51 AM] [Screen Shot 2022-10-08 at 9.17.43 AM] you guys are overthinking this problem… LOL

Historically, whenever I have to do any formatting or math with dates and time, I’ve found it easiest to make the table in Google Sheets and do the calculations and conversions on the Google side of things. There are a lot more functions giving much more control over what Glide can do with dates an…

yep… you are absolutely right! but… it takes time to sync with GS and if you are using only Glide tables, a little bit of brain gymnastics will solve all problems :wink:

[image] NFNHello: Historically, whenever I have to do any formatting or math with dates and time, I’ve found it easiest to make the table in Google Sheets and do the calculations and conversions on the Google side of things. I’ll admit that it took me a very long time to get my head around wo…

That looks like exactly what I want. How’d you configure the “Convert Duration” Column?

The big one that I haven’t taken the time to recreate the math within Glide is the “DATEDIF” function. The “YD”, “M” and “D” unit variables that do the leap year math for me is great. I’ve posted this elsewhere in more detail, but the summary is that while I COULD do the math and recreate in a Gli…

I know this. Could you show the “CONVERT DURATION” settings?

Just put that one… that’s all it is… duration/60

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

Ask for Help

Uzo October 8, 2022, 2:19pm 30

just don’t use it for other calculations in the app… only for displaying

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

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

Related topics