Change Duration Format from HH:MM:SS to HH.MM

Ask for Help
1

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 Time)*24) and the calculation is correct, but the displayed value is not in the correct format. If I double click a value in the math column to “change” the text/number within the cell, the number turns white and displays correctly (1.5) but once I click outside the number turns blue and changes to HH:MM:SS format (01:30:00).

Thanks for any help in advance.

2

Try something like this:

TRUNC((End-Start)*2400)/100
3

That worked!

Thank you so much!

4

Oh, I’ll have to try that one, @Jeff_Hager .

What I did is used a template column because I was bringing the value in from another table and the calc didn’t like the rollup. So, did a template column of the rollup with shows in time format and this did a math column using this formula FLOOR(T/60) / 60. This gives you the value in hours, so 1 hour, 30 mins would be 1.5 hours.

5

Interesting. Just tried that out and it works too. Seems like it required the template for some reason, in between the math duration and the second math with your formula, which was weird.

6

I honestly don’t know why, but ya, it works. :slight_smile: Been using it for contract work timesheet and it all works fine.