Help

How to sum the time with formula field for datetime difference?

Topic Labels: Base design Formulas
995 3
cancel
Showing results for 
Search instead for 
Did you mean: 
SpelaU
7 - App Architect
7 - App Architect

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?

SpelaU_0-1716185596529.png

Thanks

3 Replies 3

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

SpelaU
7 - App Architect
7 - App Architect

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