# The format of a duration column is not applied to the column summary **URL:** \ **Category:** Bugs\ **Created:** [January 20, 2020, 8:01pm UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363 "2020-01-20T20:01:29Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Andres\_Riofrio](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andres_riofrio/32/2981_2.png) [@Andres\_Riofrio](https://connect.superhuman.com/u/Andres_Riofrio)\ **Post date:** [January 20, 2020, 8:01pm UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/1 "2020-01-20T20:01:29Z")
For example, if the duration format is to display as hours, the content cells will show durations greater than 24 hours as hours, but the summary sum will not. Here’s a demonstration: https://coda.io/embed/ez-M3_gUOw?viewMode=embed ---
**Author:** ![Thomas\_Robbs1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_robbs1/32/9234_2.png) [@Thomas\_Robbs1](https://connect.superhuman.com/u/Thomas_Robbs1)\ **Post date:** [April 17, 2020, 5:49pm UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/2 "2020-04-17T17:49:41Z")
Yes please fix this. When I need to summarize hours for a week in a timesheet, or in a month for an invoice, I’d rather not have to do mental math because it won’t respect the format of the column. Thanks! Edit: This also affects Charts that you might want to do. If you were charting your durations it would change the axis into numbers relative to days rather than the format chosen, hours in this case. So you start to see something like this… ![image](https://global.discourse-cdn.com/coda1/original/2X/f/f826ca980ab87ec4f7a0a104607b74a142b06a18.png) ---
**Author:** ![Thomas\_Pernet](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_pernet/32/7882_2.png) [@Thomas\_Pernet](https://connect.superhuman.com/u/Thomas_Pernet)\ **Post date:** [January 9, 2021, 5:51am UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/3 "2021-01-09T05:51:21Z")
Hi @Thomas_Robbs1 , I also have this issue… The workaround is the following `thisRow.Duration.AbsoluteValue()*24` where `Duration` is the column with the Duration format ---
**Author:** ![Bjorn\_Hansell](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/bjorn_hansell/32/17961_2.png) [@Bjorn\_Hansell](https://connect.superhuman.com/u/Bjorn_Hansell)\ **Post date:** [January 29, 2021, 5:48am UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/4 "2021-01-29T05:48:57Z")
I wish this could be fixed soon. It’s an annoying bug that is tricky to work around when making graphs that should be displaying hours. ---
**Author:** ![Bjorn\_Hansell](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/bjorn_hansell/32/17961_2.png) [@Bjorn\_Hansell](https://connect.superhuman.com/u/Bjorn_Hansell)\ **Post date:** [February 1, 2021, 5:38pm UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/5 "2021-02-01T17:38:38Z")
This problem affects any formula using data from cells of the type “duration”. Formulas will format results as “days, hrs, min, s”, no matter how the original cells are set to display their data. ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [February 1, 2021, 7:54pm UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/6 "2021-02-01T19:54:57Z")
Have you tried to add a field to your table and convert your full `Duration` (x days, y hrs, z mins) by using formulas such as : - [ToDays()](https://coda.io/formulas#ToDays) - [ToHours()](https://coda.io/formulas#ToHours) - [ToMinutes()](https://coda.io/formulas#ToMinutes) - [ToSecondes()](https://coda.io/formulas#ToSeconds) There might be other ways, depending on your needs/desired results 😊 ---
**Author:** ![Bjorn\_Hansell](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/bjorn_hansell/32/17961_2.png) [@Bjorn\_Hansell](https://connect.superhuman.com/u/Bjorn_Hansell)\ **Post date:** [February 2, 2021, 12:53am UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/7 "2021-02-02T00:53:51Z")
Thanks @Pch, I’m using that workaround when possible. It’s not always possible though, for example in the automatic summary of columns. ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [February 2, 2021, 7:26am UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/8 "2021-02-02T07:26:59Z")
@Bjorn_Hansell : Well, if you want to use a `Duration` in hours (for example) strictly, you should `Summarize` that field … 😇 . Or maybe create another “Summary” table just to summarize what you need, which might be more flexible 😊 ![2021-02-02 à 08.12.48](https://global.discourse-cdn.com/coda1/original/3X/5/e/5e2c837441c75aaef47fb8b670d32c4e75936b31.png) But, yes, I agree that you won’t be able to switch between durations “formats” when you `Summarize` a field 😊 . ---
**Author:** ![Bettina\_Horvath](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/bettina_horvath/32/35388_2.png) [@Bettina\_Horvath](https://connect.superhuman.com/u/Bettina_Horvath)\ **Post date:** [June 2, 2023, 7:33am UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/9 "2023-06-02T07:33:45Z")
Thanks, this is a great workaround for me! ---
**Author:** ![Landsil](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/landsil/32/44020_2.png) [@Landsil](https://connect.superhuman.com/u/Landsil)\ **Post date:** [June 2, 2023, 8:02am UTC](https://connect.superhuman.com/t/the-format-of-a-duration-column-is-not-applied-to-the-column-summary/13363/10 "2023-06-02T08:02:46Z")
Have there been any development here since then? Not respecting settings put in a column and pulling data from it is really annoying, especially considering that there are no other settings to adjust this in sum / formula that displays data. Workarounds are all well and good but either: 1. I’m a paid customer and have to use workarounds for a 2y old bug in a paid product. 2. I’m a free user and have to use more of my limited data quota to fix a bug.