How to convert minutes to fractional hours

[Elara]

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


"Elara" <[email protected]> wrote in message
news:[email protected]...
>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!

[Elara]

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" <[email protected]> wrote in message
> news:[email protected]...
> >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!
>
>
>

[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

--

Regards,

Peo Sjoblom

"Elara" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >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!
> >
> >
> >

[Elara]

Thanks Peo.... This helps a lot!

"Peo Sjoblom" wrote:

> 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
>
> "Elara" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > >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!
> > >
> > >
> > >
>
>
>