The format of a duration column is not applied to the column summary

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:

2 Likes

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…

1 Like

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

3 Likes

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.

1 Like

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.

2 Likes

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 :

There might be other ways, depending on your needs/desired results :blush:

1 Like

Thanks @Pch, I’m using that workaround when possible. It’s not always possible though, for example in the automatic summary of columns.

1 Like

@Bjorn_Hansell : Well, if you want to use a Duration in hours (for example) strictly, you should Summarize that field … :innocent: .

Or maybe create another “Summary” table just to summarize what you need, which might be more flexible :blush:

But, yes, I agree that you won’t be able to switch between durations “formats” when you Summarize a field :blush: .

1 Like

Thanks, this is a great workaround for me!

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.