Re: $$Excel-Macros$$ How to calculate Days and Time. (Formula Req.)

2012-08-01 Thread Ashish kumar
rded message -- From: vijayajith VA Date: 31 July 2012 22:49 Subject: Re: $$Excel-Macros$$ How to calculate Days and Time. To: excel-macros@googlegroups.com Please ignore.. showing wrong answer On Wed, Aug 1, 2012 at 11:15 AM, vijayajith VA wrote: > Hi kumar, > > Try this.. &g

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-31 Thread vijayajith VA
Please ignore.. showing wrong answer On Wed, Aug 1, 2012 at 11:15 AM, vijayajith VA wrote: > Hi kumar, > > Try this.. > > =DATEDIF(A3,E3,"md") > =TEXT(B3+F3,"[HH]:MM") > > > On Tue, Jul 31, 2012 at 11:48 PM, xlstime wrote: > >> PFA THE ATTACHED MAY BE SOLUTION >> >> >> >> On Tue, Jul 31, 2012 at

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-31 Thread vijayajith VA
Hi kumar, Try this.. =DATEDIF(A3,E3,"md") =TEXT(B3+F3,"[HH]:MM") On Tue, Jul 31, 2012 at 11:48 PM, xlstime wrote: > PFA THE ATTACHED MAY BE SOLUTION > > > > On Tue, Jul 31, 2012 at 11:35 PM, Ashish kumar > wrote: > >> Dear Champs, >> >> I need to consider the time difference between both the

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-31 Thread xlstime
PFA THE ATTACHED MAY BE SOLUTION On Tue, Jul 31, 2012 at 11:35 PM, Ashish kumar wrote: > Dear Champs, > > I need to consider the time difference between both the countries. I want > to calculate the overall time consumed for the dispatch to be delivered, > kindly find the attached example sheet

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-31 Thread Ashish kumar
Dear Champs, I need to consider the time difference between both the countries. I want to calculate the overall time consumed for the dispatch to be delivered, kindly find the attached example sheet of query. Thanks Ashish On 31 July 2012 10:58, ashish koul wrote: > can you attach the sample

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-31 Thread Ashish kumar
Dear Champs, I need to consider the time difference between both the countries. I want to calculate the overall time consumed for the dispatch to be delivered. Thanks Ashish On 30 July 2012 11:36, Sam Mathai Chacko wrote: > Either way, you need to consider the time difference between both the

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-31 Thread ashish koul
can you attach the sample file On Tue, Jul 31, 2012 at 11:26 PM, kumar.ashish861 wrote: > Dear Champs, > > I need to consider the time difference between both the countries. I want > to calculate the overall time consumed for the dispatch to be delivered. > > > Thanks > Ashish > > > > > On Monda

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-31 Thread kumar.ashish861
Dear Champs, I need to consider the time difference between both the countries. I want to calculate the overall time consumed for the dispatch to be delivered. Thanks Ashish On Monday, July 30, 2012 10:55:20 AM UTC-7, Paul Schreiner wrote: > > What kind of solution are you looking for? > A

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-30 Thread Sam Mathai Chacko
Either way, you need to consider the time difference between both the countries. Only then will you actually be able to calculate the overall time consumed for the dispatch to be delivered. Sam Mathai Chacko On Mon, Jul 30, 2012 at 11:25 PM, Paul Schreiner wrote: > What kind of solution are you l

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-30 Thread Paul Schreiner
What kind of solution are you looking for? A formula or VBA?   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - Jo