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
Hey there. I find that when dealing with time, it's always best to use a decimal number for times, instead of actual times; especially when adding and subtracting. My advice would be to change your time column to type number, write the measure, and then change the measure display type to h:mm:ss or if the sum is over 24 hrs, [H]:mm:ss. Should work!