 |
 | 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 / New Users / May 2008Convert time number 9:30 to a whole number 9.5
Is there a way to convert a time number: 9:30 (9 hrs 30 minutes) to a whole (w/fraction, or one decimal to the left)? 9.5 Thanks You! Wayne > Is there a way to convert a time number: 9:30 (9 hrs 30 minutes) > to a whole (w/fraction, or one decimal to the left)? 9.5 > > Thanks You! > Wayne Multiply by 24 and reformat cell to General Ken Johnson Multiply by 24 A1 = 9:30 (h:mm) =A1*24 Format as GENERAL or NUMBER  SignatureBiff Microsoft Excel MVP > Is there a way to convert a time number: 9:30 (9 hrs 30 minutes) > to a whole (w/fraction, or one decimal to the left)? 9.5 > > Thanks You! > Wayne Bonsour® WGD avec ferveur ;o))) vous nous disiez : > Is there a way to convert a time number: 9:30 (9 hrs 30 minutes) > to a whole (w/fraction, or one decimal to the left)? 9.5 Literally: How many hours in A1 (9:30) =A1 /"1:" format cell to General 9,50 by extension: How many minutes in A1 (9:30) =A1 / "0:1" format cell to General 570 How many secondes in A1 (9:30) =A1 / "0:0:1" format cell to General 34200 HTH Signature-- @+ ;o)))
|
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.