Re: $$Excel-Macros$$ difference time calculation

2011-09-02 Thread NOORAIN ANSARI
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 . 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 us

Re: $$Excel-Macros$$ difference time calculation

2011-09-02 Thread Ms-Exl-Learner .
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 wrote: > Dear W

Re: $$Excel-Macros$$ difference time calculation

2011-09-02 Thread Shaik Waheed
Thnx On Fri, Sep 2, 2011 at 5:11 PM, NOORAIN ANSARI 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 wrote: >> >> Hi Noorain, >> Can u plz tell me y we r using TExt Function here. >> >> O

Re: $$Excel-Macros$$ difference time calculation

2011-09-02 Thread NOORAIN ANSARI
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 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 > wrote: > > Dear Jayendra,

Re: $$Excel-Macros$$ difference time calculation

2011-09-02 Thread Shaik Waheed
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 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.blo

RE: $$Excel-Macros$$ difference time calculation

2011-08-19 Thread Rajan_Verma
Its mean Minuts/Hour -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of XLS S Sent: Friday, August 19, 2011 7:30 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ difference time calculation hey rajan, what is the

Re: $$Excel-Macros$$ difference time calculation

2011-08-19 Thread XLS S
: Friday, August 19, 2011 1:28 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ difference time calculation > > > > Dear team, > > > > > > Kindly help me in this regards > > > > > > > > -- > J.Gaurav > Operation Manager

RE: $$Excel-Macros$$ difference time calculation

2011-08-19 Thread Rajan_Verma
Try this =((C2+D2)-(A2+B2))*1440/60 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jayendra gaurav Sent: Friday, August 19, 2011 1:28 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ difference time calculation Dear team

Re: $$Excel-Macros$$ difference time calculation

2011-08-19 Thread Venkat CV
Great Noorain, *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 19, 2011 at 2:45 PM, NOORAIN ANSARI 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.c

Re: $$Excel-Macros$$ difference time calculation

2011-08-19 Thread NOORAIN ANSARI
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 wrote: > Dear team, > > > Kindly h

$$Excel-Macros$$ difference time calculation

2011-08-19 Thread jayendra gaurav
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 o