# Additional Rollup options for Date/Time Math Columns **URL:** \ **Category:** Feature Requests\ **Created:** [September 29, 2020, 11:18am UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499 "2020-09-29T11:18:30Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [September 29, 2020, 11:18am UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/1 "2020-09-29T11:18:30Z")
I just noticed that date/time math columns don’t have rollup options for Average, sum, minimum, maximum etc. While Math columns are also numbers and hence should have the same rollup options which numbers have. Can this be applied? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8511625c56bfd8f24777083053046fdd1c7727c3.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 29, 2020, 11:44am UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/2 "2020-09-29T11:44:19Z")
You are rollup over a time related math isn’t it? Probably the data is seen as datetime and not number. ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [September 29, 2020, 11:46am UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/3 "2020-09-29T11:46:17Z")
I tried to manipulate it but I believe these rollup options aren’t available for date/time based math columns. I should change the feature request. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 29, 2020, 1:27pm UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/4 "2020-09-29T13:27:24Z")
Does it work if you create a template of the date math column and then rollup the template column? ---
**Author:** ![fabio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabio/32/16336_2.png) [@fabio](https://community.glideapps.com/u/fabio)\ **Post date:** [January 23, 2021, 10:30am UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/5 "2021-01-23T10:30:45Z")
Dear all, I have the same/similar problem. I am unable to sum date math column. Let’s say I have a training sheet where I can do run, bike, football or basket In each row I have the activity, a start date column, a finish date column and a math which makes finish-start date. And this is ok. I have a column which relates all the date\_differences according to the activity (basket, run,footbal,bike), and it’s ok. I am unable to sum the value of the date differences related to the activities. I would like to sum how many hours I spent for bike, how many for football, how many for bike and how many for running. Seems to me impossible to sum the value I get in the relation column… but rollup is not giving me the “sum” choice, only “count” and “count unique” Tried with template column, without success…I cannot rollup it Any suggestion? @Jeff_Hager @Manan_Mehta @ThinhDinh Thanks ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [April 20, 2021, 8:05am UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/6 "2021-04-20T08:05:45Z")
Totally agree with this, +10000000 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 20, 2021, 8:32am UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/7 "2021-04-20T08:32:55Z")
This is perfectly doable. The trick is to first convert the date differences to durations in seconds using a math column `(end - start) * 86400`. You can then rollup the durations to get a sum, and then convert that back to hh:mm:ss. @Manan_Mehta @fabio ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [April 20, 2021, 11:37am UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/8 "2021-04-20T11:37:49Z")
Aahhaa, let’s try. I’ll get back if it doesn’t. Nevertheless, it should be simpler… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 20, 2021, 11:47am UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/9 "2021-04-20T11:47:53Z")
I know it works, because I’ve used that method 😛 (In fact, I used that method in Mark’s Agent app to get the rollups of his Agent session durations) ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [April 20, 2021, 12:32pm UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/10 "2021-04-20T12:32:46Z")
Totally does!! Thank you Darren ---
**Author:** ![Bahadir\_Kaya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bahadir_kaya/32/14065_2.png) [@Bahadir\_Kaya](https://community.glideapps.com/u/Bahadir_Kaya)\ **Post date:** [July 16, 2022, 3:48pm UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/11 "2022-07-16T15:48:50Z")
> [@Darren\_Murphy](#): > > 86400 I have a problem with date maths ☹ I have 2 columns First: Project Start Date (With Seconds) End: Project Finish Date (With Seconds) When I make math column for that 2 columns ( End-First) I have results like that: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0cd51626049cc327762f84a9edcb9e0938a04ce2.png) After that i will use for sum calculation for per project managers. But it makes me crayz ☹ Someone can help me please? I need calculation for total seconds ---
**Author:** ![Bahadir\_Kaya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bahadir_kaya/32/14065_2.png) [@Bahadir\_Kaya](https://community.glideapps.com/u/Bahadir_Kaya)\ **Post date:** [July 16, 2022, 3:53pm UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/12 "2022-07-16T15:53:36Z")
I found 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/0/60c0fedd3176849eeccfe1fd503c7d66a85ffba9.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 16, 2022, 4:19pm UTC](https://community.glideapps.com/t/additional-rollup-options-for-date-time-math-columns/16499/13 "2022-07-16T16:19:12Z")
> [@Bahadir\_Kaya](#): > > I need calculation for total seconds Use this in a Math column: `Trunc((End - Start) * 86400)` ![Screen Shot 2022-07-17 at 12.21.54 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/787643e653d5077318cc0ed6021b2d6c30b93582.png) ![Screen Shot 2022-07-17 at 12.21.45 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d115f3ce4714853bb49d5a916a74e08904d12885.png)