 |
 | 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 / January 2006Decimal days
Hi Newish to Excel, so apologies if this a really stupid post. Doing an annual leave calculator which gives as one its results th decimal figure of, for example, 33.5 days, i.e. thirty three and a hal days. How can I convert this to read 33 days and 12 hours? Have tried al sorts to no avail. Many thanks Clif -- cliffbellis766 > .. Doing an annual leave calculator which gives as one its results the > decimal figure of, for example, 33.5 days, > i.e. thirty three and a half days. > How can I convert this to read 33 days and 12 hours? One way which might suffice .. Assuming the results (33.5, etc) are in A2 down Put in B2: =IF(A2=0,"",IF(A2=INT(A2),INT(A2)&" days",INT(A2)&" days and "&(A2-INT(A2))*24&" hours")) Copy down -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- Maybe try this slightly revised formula instead: Put in B2: =IF(A2=0,"",IF(A2=INT(A2),INT(A2)&" days",INT(A2)&" days and "&TEXT((A2-INT(A2))*24,"00")&" hours")) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- Hi Cliff One way, with days in A1 =INT(A1)&" days "&MOD((A1*24),24)&" hours"  SignatureRegards Roger Govier cliffbellis766@ <cliffbellis766.2100ny_1136190601.1358@excelforum-nospam.com> wrote: > Hi > Newish to Excel, so apologies if this a really stupid post. [quoted text clipped - 12 lines] > http://www.excelforum.com/member.php?action=getinfo&userid=29310 View > this thread: http://www.excelforum.com/showthread.php?threadid=497313 Hello all Many, many thanks; now got it working. No wonder my brain cell wa having problems working this one out. No more staff claiming extra minutes of undeserved leave! Hah! that'l teach 'em. Really grateful, although staff are preparing scaffold for me. Clif -- cliffbellis766 |
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.