How to convert minutes to fractional hours

[Guest]

I am trying to convert minutes into fractional hours but I don't know how. I
already have a spreadsheet with over 100 employees and the overtime minutes
they have worked. I want to change all to fractional hours instead of
minutes. I think that's what it's called... you know 105 minutes = 1.75
hours. I know I can just divide by 60 but I don't even know how to do that.
Can someone pretty please help me... Thank you!

 

[Sandy]

Assuming you have the minutes total in cell A2 then in cell A3 type =A2/60

 

[Guest]

If I do that... it puts the fractional hour in cell A3, so that doesn't work.
The thing is, I have numbers in all cells from B2 - Z2, down to B100-Z100. I
want to convert all of them into fractional hours without having to do it one
by one. How do I do this? Thanks a million

 

[Peo Sjoblom]

Put 60 in an empty cell, copy it, select all the minutes and do edit>paste
special and select divide. Note that it won't give you an audit trail
doing this, yiou can also create a mirror sheet and use a formula

=Sheet1!B1/60

(replace sheet name with real sheet name)

then just copy down and across

 

[Guest]

Thanks Peo.... This helps a lot!

Put 60 in an empty cell, copy it, select all the minutes and do edit>paste
special and select divide. Note that it won't give you an audit trail
doing this, yiou can also create a mirror sheet and use a formula

=Sheet1!B1/60

(replace sheet name with real sheet name)

then just copy down and across

--

Regards,

Peo Sjoblom