you are welcome dear.... stay smart
On 8/24/08, Ashish Khandelwal <[EMAIL PROTECTED]> wrote: > > > Thanks for your answer the formula is working as was required. > > > > On 8/21/08, Munson, Herb <[EMAIL PROTECTED]> wrote: >> >> If cell A1 contains the value, then I think the first expression below >> will satisfy your first req't, the second, your second. >> >> >> >> =INT(A1) & " hour and " & TEXT((A1-INT(A1))*60,"0") & " minutes" >> >> =INT(A1)+(A1-INT(A1))*60/100 >> >> >> ------------------------------ >> >> *From:* excel-macros@googlegroups.com [mailto: >> [EMAIL PROTECTED] *On Behalf Of *Ashish Khandelwal >> *Sent:* Wednesday, August 20, 2008 10:26 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ figures in minutes >> >> >> >> Hello, >> >> I want to change figures in minutes or hour. Say if it is written 145.50 >> then it should say 145 hour and 30 minutes or 145.30 hour. >> >> >> >> Ashish. >> >> >> >> >> > > > > -- Stay Beautiful, Always. Abdul Salam Accounts Officer Elysium Holdings Pakistan Ltd. (:+92-321-5001- 361 * [EMAIL PROTECTED] P Save a tree...please don't print this e-mail unless you really need to --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
