Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 19, 2024 11:14 PM
Hi!
I have formula field for duration of a lunch break (datetime difference between lunch strat and lunch end). It gives me duration in minutes. Now I'm wondering if there is a way to sum this time?
Thanks
May 19, 2024 11:27 PM
I think you're going to need to have a summary table where you link the records in your screenshot to a single record in the summary table and use rollups for that I'm afraid
May 20, 2024 05:35 AM
Great, thanks for help Adam!
May 21, 2024 07:20 PM
Hi,
it seems like you have 2 more rows not shown on the screenshot with a lack of input data (start without end or vice versa). Add it or fix the formula (like show difference result only when both fields are filled) to get rid of infinity.
Then you can see the sum.
To get it as value in table, you need to rollup as @TheTimeSavingCo said