Hi, how do I convert hours, minutes and seconds? example 08:22:10 to 8 hours 22 minutes 10 seconds [image]

I’ve used Chuck’s solution before [image] Time duration not presenting correctly in glide chart stopwatch Ask for Help I took it a step further and included Days as well. You can exclude it if you don’t need it. It’s a little involved, but I’ll explain the best I can. Here is my results: [image] First we have the Duration column, which is obvious and what you already have. Next we have the Days column: [image] FLOOR(D)/100 This is simply taking the duration and dropping off the decimals. The division by 100 will be explained later. Next we have the Hours column: [image] FLOOR(MOD(D,1)*24)/100 Th…

Do try Jeff’s solution out you’ll learn a thing from there (I already have) Also I made a JS code for this case function convertTime(p1) { p1 = p1.replace(/(AM|PM)$/i, "").trim(); let timeParts = p1.split(":"); if (timeParts.length === 2) { timeParts.push("00"); } else if (timeParts.length === 1) { timeParts.push("00", "00"); } const [hours, minutes, seconds] = timeParts; const formattedHours = Number(hours); const formattedMinutes = Number(minutes); const formattedSeconds = Number(seconds); const hourLabel = formattedHours === 1 ? "hour" : "hours"; const minuteLabel = formattedMinutes === 1 ? "minute" : "minutes"; const secondLabel = formattedSeconds === 1 ? "second" : "seconds"; return `${formattedHours} ${hourLabel} ${formattedMinutes} ${minuteLabel} ${formattedSeconds} ${secondLabel}`; } return convertTime(p1); if this doesn’t work with the date column it needs only a time value, the date columnn doesn’t provide a time only value, so you can pass this to a template column. That said it’s possible to parse the cell and get just the time

Convert time

Ask for Help

Eric_Penn October 22, 2024, 4:36pm 2

I’ve used Chuck’s solution before

Topic		Replies	Views
How to convert HH:MM:SS to just HH:MM? Ask for Help	40	4118	October 9, 2022
Time duration not presenting correctly in glide chart ⏱ Ask for Help	8	1981	March 10, 2021
Can I convert seconds to minutes? Ask for Help	22	626	December 22, 2022
Convert Minutes to Hour and Minutes Ask for Help	5	1305	February 24, 2023
How to convert decimal to duration? Ask for Help	20	1968	June 11, 2022

Convert time

Related topics