Yes MS. EXL Leaner, You can also use same format *[H]:mm:ss* in Custom Format.
On Fri, Sep 2, 2011 at 10:16 PM, Ms-Exl-Learner . <ms.exl.lear...@gmail.com>wrote: > Hi Noorain Ansari, > > But the text function will result text value instead of real value. It's > better to format the cell as per your desired format by using custom format. > > ----------------------- > Ms.Exl.Learner > ----------------------- > > On Fri, Sep 2, 2011 at 5:11 PM, NOORAIN ANSARI <noorain.ans...@gmail.com > > wrote: > >> Dear Waheed, >> >> Text Function are used to convert time differences as Hour:Minute:Second >> Format. >> >> On Fri, Sep 2, 2011 at 5:02 PM, Shaik Waheed <waheedb...@gmail.com>wrote: >> >>> Hi Noorain, >>> Can u plz tell me y we r using TExt Function here. >>> >>> On Fri, Aug 19, 2011 at 2:45 PM, NOORAIN ANSARI >>> <noorain.ans...@gmail.com> wrote: >>> > Dear Jayendra, >>> > >>> > Please use below formula & see attached sheet.. >>> > >>> > =TEXT((C2+D2)-(A2+B2),"[H]:mm:ss") >>> > >>> > -- >>> > Thanks & regards, >>> > Noorain Ansari >>> > http://noorain-ansari.blogspot.com/ >>> > On Fri, Aug 19, 2011 at 1:28 PM, jayendra gaurav < >>> jayendra.gau...@gmail.com> >>> > wrote: >>> >> >>> >> Dear team, >>> >> >>> >> Kindly help me in this regards >>> >> >>> >> >>> >> >>> >> -- >>> >> J.Gaurav >>> >> Operation Manager >>> >> >>> >> -- >>> >> >>> >> >>> ---------------------------------------------------------------------------------- >>> >> Some important links for excel users: >>> >> 1. Follow us on TWITTER for tips tricks and links : >>> >> http://twitter.com/exceldailytip >>> >> 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >> >>> >> To post to this group, send email to excel-macros@googlegroups.com >>> >> >>> >> <><><><><><><><><><><><><><><><><><><><><><> >>> >> Like our page on facebook , Just follow below link >>> >> http://www.facebook.com/discussexcel >>> > >>> > >>> > >>> > -- >>> > >>> ---------------------------------------------------------------------------------- >>> > Some important links for excel users: >>> > 1. Follow us on TWITTER for tips tricks and links : >>> > http://twitter.com/exceldailytip >>> > 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> > >>> > To post to this group, send email to excel-macros@googlegroups.com >>> > >>> > <><><><><><><><><><><><><><><><><><><><><><> >>> > Like our page on facebook , Just follow below link >>> > http://www.facebook.com/discussexcel >>> > >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel