# How to display hours correctly in charts (without converting to days)

**URL:** <https://connect.superhuman.com/t/how-to-display-hours-correctly-in-charts-without-converting-to-days/58557>\
**Category:** Ask the Community\
**Created:** [November 4, 2025, 7:27am UTC](https://connect.superhuman.com/t/how-to-display-hours-correctly-in-charts-without-converting-to-days/58557 "2025-11-04T07:27:12Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carlos\_Moreno](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/carlos_moreno/32/43362_2.png) [@Carlos\_Moreno](https://connect.superhuman.com/u/Carlos_Moreno)\
**Post date:** [November 4, 2025, 7:27am UTC](https://connect.superhuman.com/t/how-to-display-hours-correctly-in-charts-without-converting-to-days/58557/1 "2025-11-04T07:27:12Z")

</div>

Hi everyone 👋  
I’m creating a chart in Coda that shows the total hours, but when the values go over 24 hours, Coda automatically converts them into days.  
For example, if I have 22h + 22h, instead of showing “44h”, the chart displays “1 day 20h”.

Does anyone know how to make charts display the accumulated hours as plain hours (like 44h) without converting them to days?  
Thanks in advance! 🙏

---

<div class="post-metadata">

**Author:** ![Max\_OBrien](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/max_obrien/32/49285_2.png) [@Max\_OBrien](https://connect.superhuman.com/u/Max_OBrien)\
**Post date:** [November 4, 2025, 8:50am UTC](https://connect.superhuman.com/t/how-to-display-hours-correctly-in-charts-without-converting-to-days/58557/2 "2025-11-04T08:50:52Z")

</div>

my suggestion would be to add a column to your table called `Hours` with the formula

`ProjectDuration.ToHours().toNumber()`

so it computes the hours as a plain number.

then you can use that in your chart.

max

---

<div class="post-metadata">

**Author:** ![Max\_OBrien](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/max_obrien/32/49285_2.png) [@Max\_OBrien](https://connect.superhuman.com/u/Max_OBrien)\
**Post date:** [November 4, 2025, 1:29pm UTC](https://connect.superhuman.com/t/how-to-display-hours-correctly-in-charts-without-converting-to-days/58557/3 "2025-11-04T13:29:13Z")

</div>

actually…

i believe `.ToHours()` returns a NUMBER and not a DURATION  
so you probably do not need to add the `.ToNumber()` at the end.

max

---

<div class="post-metadata">

**Author:** ![Carlos\_Moreno](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/carlos_moreno/32/43362_2.png) [@Carlos\_Moreno](https://connect.superhuman.com/u/Carlos_Moreno)\
**Post date:** [November 4, 2025, 1:44pm UTC](https://connect.superhuman.com/t/how-to-display-hours-correctly-in-charts-without-converting-to-days/58557/4 "2025-11-04T13:44:04Z")

</div>

but I want the chart to show something like this: 44h 30min, not like 44.50. that’s what I’m not sure can be done in Coda

---

<div class="post-metadata">

**Author:** ![Max\_OBrien](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/max_obrien/32/49285_2.png) [@Max\_OBrien](https://connect.superhuman.com/u/Max_OBrien)\
**Post date:** [November 4, 2025, 4:15pm UTC](https://connect.superhuman.com/t/how-to-display-hours-correctly-in-charts-without-converting-to-days/58557/5 "2025-11-04T16:15:32Z")

</div>

use the `Format()` formula to define how the hours and minutes should be displayed

`Format(‘{1:00}:{2:00}’,DURATION.Hour(),DURATION.Minute())`

This pads the hour and minute values to 2 digits each with a colon between them

---

<div class="post-metadata">

**Author:** ![Melanie\_Teh](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/melanie_teh/32/45501_2.png) [@Melanie\_Teh](https://connect.superhuman.com/u/Melanie_Teh)\
**Post date:** [November 4, 2025, 4:15pm UTC](https://connect.superhuman.com/t/how-to-display-hours-correctly-in-charts-without-converting-to-days/58557/6 "2025-11-04T16:15:44Z")

</div>

👋@Carlos_Moreno

you can set the duration column to show only hours and then create a helper text column pointing at duration column and it will display as your intended format i.e. 44hr etc

 ![Screenshot 2025-11-05 at 12.11.23 AM](https://global.discourse-cdn.com/coda1/original/3X/0/3/03b6814cc86eb8ec77709183214f5a65f11408d0.png)

here is the reference you can copy should you require more detail.

https://coda.io/embed/ADwg9UrMqC?viewMode=embed

hope this helps!

Cheers!  
Mel