 |
 | 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 / August 2006Convert to time
How would I go about converting 8.00 to 8:00:00 AM in excel. Can this be done? Floyd Forbes Wrote: > How would I go about converting 8.00 to 8:00:00 AM in excel. > Can this be done? Hi Floyd If A1 contains 8.00 format A2 to Time, then input =(A1/24)+A1 oldchippy : Hi old chippy, > =(A1/24)+A1 does show as 8:00 when formatted as time but it is 8 AM on January 8 1900 - reformat as General and you will see that the cell contains 8.33333333333. As you probably know, the *8* represents day number 8  SignatureRegards, Sandy In Perth, the ancient capital of Scotland sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > Floyd Forbes Wrote: >> How would I go about converting 8.00 to 8:00:00 AM in excel. [quoted text clipped - 8 lines] > > oldchippy :) Divide by 24 and format as time. =a1/24 (8.50 will convert to 8:30 AM) > How would I go about converting 8.00 to 8:00:00 AM in excel. > Can this be done? SignatureDave Peterson Assuming your value is in A1, try this: =VALUE(INT(A1)&":"&MOD(A1,1)*60&":00") and use a custom format on the cell to display it with AM/PM. Hope this helps. Pete > How would I go about converting 8.00 to 8:00:00 AM in excel. > Can this be done? Just to be different <g> Pete > Assuming your value is in A1, try this: > [quoted text clipped - 8 lines] > > How would I go about converting 8.00 to 8:00:00 AM in excel. > > Can this be done? Thank you, But when I key 8.15 it gives me 8:09. How do I convert 8.15 to 8:15? > Just to be different <g> > [quoted text clipped - 12 lines] >> > How would I go about converting 8.00 to 8:00:00 AM in excel. >> > Can this be done? If you are entering hours and minutes as hh.mm (using a full-stop to separate them rather than the colon), you can convert this to normal time format as follows: =VALUE(INT(A1)&":"&MOD(A1,1)*100&":0") I assumed earlier (as did the other responders) that you had hours and decimal minutes, hence the factor of 60. Hope this helps. Pete > Thank you, But when I key 8.15 it gives me 8:09. How do I convert 8.15 to > 8:15? [quoted text clipped - 15 lines] > >> > How would I go about converting 8.00 to 8:00:00 AM in excel. > >> > Can this be done? Pete_UK, When I key 8.20 I get #############################################. How can I get 8:20 to show? > If you are entering hours and minutes as hh.mm (using a full-stop to > separate them rather than the colon), you can convert this to normal [quoted text clipped - 28 lines] >> >> > How would I go about converting 8.00 to 8:00:00 AM in excel. >> >> > Can this be done? I think you're getting hit by too many digits: =VALUE(INT(A1)&":"&ROUND(MOD(A1,1)*100,0)&":0") Seems to work ok. > Pete_UK, When I key 8.20 I get > #############################################. [quoted text clipped - 32 lines] > >> >> > How would I go about converting 8.00 to 8:00:00 AM in excel. > >> >> > Can this be done? SignatureDave Peterson Just another way: =INT(A1)/24+(MOD(A1,1))/14.4 SignatureHTH Sandy In Perth, the ancient capital of Scotland sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > If you are entering hours and minutes as hh.mm (using a full-stop to > separate them rather than the colon), you can convert this to normal [quoted text clipped - 28 lines] >> >> > How would I go about converting 8.00 to 8:00:00 AM in excel. >> >> > Can this be done? One more: =TIME(INT(A1),MOD(A1,1)*100,0) > Thank you, But when I key 8.15 it gives me 8:09. How do I convert 8.15 to > 8:15? [quoted text clipped - 15 lines] > >> > How would I go about converting 8.00 to 8:00:00 AM in excel. > >> > Can this be done? SignatureDave Peterson Thank you for your help. You are the best. Floyd Floyd Turks & caicos Islands B.W.I > One more: > [quoted text clipped - 19 lines] >> >> > How would I go about converting 8.00 to 8:00:00 AM in excel. >> >> > Can this be done? |
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.