How to convert minutes to fractional hours
 

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!

How to convert minutes to fractional hours
 

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


"Elara" wrote in message
...
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!

How to convert minutes to fractional hours
 

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

"Sandy" wrote:

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


"Elara" wrote in message
...
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!

How to convert minutes to fractional hours
 

Put 60 in an empty cell, copy it, select all the minutes and do editpaste
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

"Elara" wrote in message
...
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

"Sandy" wrote:

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


"Elara" wrote in message
...
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!

How to convert minutes to fractional hours
 

Thanks Peo.... This helps a lot!

"Peo Sjoblom" wrote:

Put 60 in an empty cell, copy it, select all the minutes and do editpaste
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

"Elara" wrote in message
...
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

"Sandy" wrote:

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


"Elara" wrote in message
...
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!