Stupid excel question. I have 0.90. I need it to read 1.30 Hr & Min 3

[coolcarls]

So, I need to convert minutes, to hours and minutes. I know it's an easy formula, I just don't know/remember it. HELP!!!

 

[Bowers74]

Set the format of your cell to the custom format h.mm and then enter the formula =(A1*100)/1440 into the cell.

I hope this helps!



Peace!!

Mike

Didn't get the answers that you wanted? Then . . . Click Here

 

[TonyJollans]

Hi coolcarls,

If you have [purple]90[/purple] in A1, then in another cell you can put ..

[blue][tt]=INT(A1/60)&"hr "&MOD(A1,60)&"min"[/tt][/blue] just to format it yourself, or ..

[blue][tt]=A1/1440[/tt][/blue] and format the cell as Time, or ..

[blue][tt]=TEXT(A1/1440,"hh:mm")[/tt][/blue] to format the time yourself, or ....

If you have [purple]0.90[/purple] as the title says then you'll have to multiply all the calculations by 100.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[coolcarls]

Thanks guys!
Arrrgh, I knew it had something to do with the 1440

Thanks a lot