How to convert whole number to hours

[ggr]

Hi

I need some help on which formula to use to convert a whole number to hour.minute format

example - 587.6 minutes should be converte to hours and the outcome should be 10.06 hours.

Many thanks

[vlady]

Hello ggr.
Welcome to the forum
Try this.
assuming in cell A1 you have 587.6

in B1 type

Please Login or Register  to view this content.

[Philb1]

If you want the result in decimal you could use this. Enter the number of minutes in A1. 587.6 minutes = 9.79 hours

Please Login or Register  to view this content.

Have Fun