Power Query - Operator Error

Hey,

I'm unable to attach sample data relating to this, so I'm hoping someone has come across the issue before and can offer advice.


I've grouped multiple 'Time' formatted fields into one. The result is that the majority of the printed fields show as 'Error', with the description saying 'expression error we cannot apply operator + to types time and time'.

For some fields this has worked, but for the majority I get the error.

I can only assume it's because time cannot exceed 24 hours, so I need a way to change the data type to [HH]:MM:SS. If that's possible?


Again, I can't attach any sample data so any advice is appreciated.

Can you post the M code?

The problem is simply that you can't add time values. You'd need to change the column type to decimal numbers, sum it, then change it back to date/time (in case it goes over 24 hours) and then deal with it as need be. You could also just leave it as decimal and work with that.