Forum Discussion
SUM Time Field
Hi all, Is it possible to SUM a Time field? Below I have summed [Rest Time 2] but instead of correctly adding up the times it gives an incorrect time
Anonymous this summarised the rest times and gave the same value for everyone - please see below
HenryJS
I guess I misunderstood you requirement. I only see the incorrect sum time. You may add filters to set context.
Table = Summarize('Engage Timesheet Export',
'Engage Timesheet Export'[Worker Name],
'Engage Timesheet Export'[Week Ending],
"Total Rest Time",Sumx(All('Engage Timesheet Export'),[Rest Time2]))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.