Sum of Hour and Minutes

[sureshsonti]

I still have an issue with calculating the sum of hours and minutes. I have hours worked by employees. I want to calculate the sum of hours and minutes 85:20 in this format (Eighty Five Hours and Twenty Minutes) and I want to convert the total hours to a decimal number. PUNCH IN and PUNCH OUT data type is TIME and format is 1:30:55 PM (h:mm:ss tt). You can ignore the 17:33, 16:40, 16:05 times. How can I sum the hours and minutes and convert them to a decimal number. Thanks

 

[v-shex-msft]

HI @sureshsonti,

Nope, date and time types not support summary functions, please convert them to total seconds to calculate and transform back to time format after calculation.

Aggregating Duration/Time

Regards,

Xiaoxin Sheng