 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2005How 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! Assuming you have the minutes total in cell A2 then in cell A3 type =A2/60 >I am trying to convert minutes into fractional hours but I don't know how. >I [quoted text clipped - 5 lines] > that. > Can someone pretty please help me... Thank you! 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 > Assuming you have the minutes total in cell A2 then in cell A3 type =A2/60 > [quoted text clipped - 7 lines] > > that. > > Can someone pretty please help me... Thank you! 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  SignatureRegards, Peo Sjoblom > 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 [quoted text clipped - 12 lines] > > > that. > > > Can someone pretty please help me... Thank you! 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 [quoted text clipped - 28 lines] > > > > that. > > > > Can someone pretty please help me... Thank you! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.