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).
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.