lets say I have a table with 3 columns
Column A = ID (Type Key)
Column B = Time Start (Type Time)
Column C = Time Finish (Type Time)
Virtual Column D = Time Spent (Type Duration) Formula = [Time Finished] - [Time start]
Virtual Column E = Total Time Spent (Type Duration) Formula = ??
I’m having trouble getting a formula together for Column E. Im looking to Sum all of Column D. Im thinking it should be Somthing like sum(Time Spent) or along those lines but everything I try along these lines does not seem to work.
Any help would be appreciated. This is a pain in my arse.