Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-28 Thread Vaibhav Joshi
> >>>>> Son >>>>> >>>>> 2014-11-24 20:47 GMT+07:00 Paul Schreiner : >>>>> >>>>> >>>>> What do these times represent? >>>>> Why would the equipment be recorded as down 9:00-12:00 AND 10:00-11:30? >>>>> >&

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-28 Thread Vaibhav Joshi
t;>>> >>>> >>>> *“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.” - John Wesley* >>>> -

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-27 Thread Vaibhav Joshi
t;>> 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.” - John Wesley* >>> - >>> >>>*From:* son nguyen >>> *To:* excel-macros@googlegroup

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-27 Thread Vaibhav Joshi
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.” - John Wesley* >> --------------------- >> >> *From:* son nguyen >> *

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-26 Thread Paul Schreiner
To: excel-macros@googlegroups.com >Sent: Tuesday, November 25, 2014 11:21 PM >Subject: Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods > > > >Hi Paul, > > >I'm sorry as my past explain isn't clear for you.Please see enclosed file and >ho

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-26 Thread son nguyen
--- >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> *“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 >>

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-25 Thread Ganesh N
> >>> >>> >>> *“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.” - John Wesley* >>>

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-25 Thread Ganesh N
- John Wesley* >> --------- >> >>*From:* son nguyen >> *To:* excel-macros@googlegroups.com >> *Sent:* Monday, November 24, 2014 11:22 PM >> *Subject:* Re: $$Excel-Macros$$ Sum downtime for equipment with overlap >> per

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-25 Thread Ganesh N
l the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* son nguyen > *To:* excel-macros@googlegroups.com > *Sent:* Monday, November 24, 2014 11:22 PM > *Subject:* Re: $$Excel-Macros$$ Sum downtime for equipment with overlap &

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-25 Thread son nguyen
he places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* son nguyen > *To:* excel-macros@googlegroups.com > *Sent:* Monday, November 24, 2014 11:22 PM > *Subject:* Re:

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-25 Thread Paul Schreiner
gt;To all the people you can, >>As long as ever you can.” - John Wesley >>- >> From: son nguyen >>>To: excel-macros@googlegroups.com >>>Sent: Saturday, November 22, 2014 11:55 PM >>>Subject: $$Excel-Macros$$ Su

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-24 Thread son nguyen
n,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.” - John Wesley* > - > >*From:* son nguyen > *To:* excel-macros@googlegroups.com > *Sent:* Saturda

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-24 Thread Paul Schreiner
ple you can, As long as ever you can.” - John Wesley - > > From: son nguyen >To: excel-macros@googlegroups.com >Sent: Saturday, November 22, 2014 11:55 PM >Subject: $$Excel-Macros$$ Sum downtime for equipment wit

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-23 Thread pp kk
use data entry like 8:00AM 8:20 AM Then 8:20 AM - 8:00 AM = 0:20 Pankaj Michael On Sun, Nov 23, 2014 at 10:25 AM, son nguyen wrote: > Dear all, > > I have problem when calculate total equipment downtime as there are > overlap periods. > For example : > start time Finish time > 8:00

$$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-22 Thread son nguyen
Dear all, I have problem when calculate total equipment downtime as there are overlap periods. For example : start time Finish time 8:00 8:20 9:00 12:00 10:00 11:30 ... start time,finish time are flexible. all of you might gi