 |
 | 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 / October 2008How to convert time expressed as a decimal to actual hours or minu
I am receiving a report from a vendor that lists call time minutes of usage in decimal form, i.e. 5.15. When I try to convert this figure into actual time format using the formula, =TEXT(G36/24,"H:MM:SS"), my return is 5:09:00. It appears this formula is returning the amount of time after midnite and not what I am looking for, which is the time expressed in actual hours and or minutes used. Hi Is 5.15 equivalent to 5 minutes and 15 seconds? If so, you could use the following to convert to Excel time (remember to format the formula cell in a time format): =(A1+MOD(A1,1)*40/60)/1440 1440 being the number of minutes in a day. Richard >I am receiving a report from a vendor that lists call time minutes of usage > in decimal form, i.e. 5.15. When I try to convert this figure into actual [quoted text clipped - 4 lines] > what I am looking for, which is the time expressed in actual hours and or > minutes used. Why not just =A1/1440  SignatureRegards, Peo Sjoblom > Hi > [quoted text clipped - 17 lines] >> what I am looking for, which is the time expressed in actual hours and or >> minutes used. Peo As my reply asked, it depends on what is represented by the .15. If it means 15/100 of a minute then your formula is indeed the correct one. Richard > Why not just > [quoted text clipped - 23 lines] >>> or >>> minutes used. Yes you are correct, sometimes I read questions too fast. I just went with the what the OP tried with his TEXT formula. SignatureRegards, Peo Sjoblom > Peo > [quoted text clipped - 30 lines] >>>> or >>>> minutes used. Ok here is my guess. 5.15 minutes is equal to 5 minutes and 9 seconds. I would use =G36/1440 and format as mm:ss. The answer = 05:09 > Yes you are correct, sometimes I read questions too fast. I just went with > the what the [quoted text clipped - 34 lines] >>>>> or >>>>> minutes used. |
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
|
©2008 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.