Hi,

I’ve performed an operation on a column which gives me a number, and I’d like to transform this number into hours.
How do I do this?
I’ve used “cell format” but it doesn’t work.
Example: my total is 9, in another cell I divide this number by 2, which gives me 4.5 and I’d like this number to appear in hourly format: 4:50 so that I can then add up several cells.

Thank you

​Hi, I’ve performed an operation on a column which gives me a number, and I’d like to transform this number into hours.How do I do this?I’ve used “cell format” but it doesn’t work.Example: my total is 9, in another cell I divide this number by 2, which gives me 4.5 and I’d like this number to appear in hourly format: 4:50 so that I can then add up several cells.Thank you  Read More

​