View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy
 
Posts: n/a
Default 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!