Hi expert,

I have a cell e.g I14 in format [h]:mm:ss and it is showing 178:50:34.

I want to convert it so that the number of hour (178) multiply by 10. Which should be equal to 1780.

So, i type a formula in another cell which is :
=HOUR(I14)*10
However, it show 2400:00:00 and the format of this cell is [h]:mm:ss which is not my expected.

Please advice?

Regards
Grace