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
How to sum the time with formula field for datetime difference?
+10
+31I 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
+25Hi,
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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.