Skip to main content

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

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

Great, thanks for help Adam!

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

Reply


Terms & Conditions