Re: $$Excel-Macros$$ Need to Subtract Two Date/Time Cells - Formula Issue

2013-03-05 Thread John A. Smith
Excellent, that saves a step. Thank you very much. John On Tue, Mar 5, 2013 at 12:05 PM, xlstime wrote: > use your formula with value and trim formula > > . > > Enjoy > Team XLS > > > > On Tue, Mar 5, 2013 at 10:24 PM, John A. Smith wrote: > >> I have a download into E

Re: $$Excel-Macros$$ Need to Subtract Two Date/Time Cells - Formula Issue

2013-03-05 Thread xlstime
use your formula with value and trim formula . Enjoy Team XLS On Tue, Mar 5, 2013 at 10:24 PM, John A. Smith wrote: > I have a download into Excel with start and stop cells which contain the > date/time. I need help making my formula work please to get the NET > minu

Re: $$Excel-Macros$$ Need to Subtract Two Date/Time Cells - Formula Issue

2013-03-05 Thread John A. Smith
Thank you very much for your helpful swift reply... John On Tue, Mar 5, 2013 at 11:55 AM, rajan verma wrote: > Just remove starting space from the date > > On Tue, Mar 5, 2013 at 9:54 AM, John A. Smith wrote: > >> I have a download into Excel with start and stop cells which contain t

Re: $$Excel-Macros$$ Need to Subtract Two Date/Time Cells - Formula Issue

2013-03-05 Thread rajan verma
Just remove starting space from the date On Tue, Mar 5, 2013 at 9:54 AM, John A. Smith wrote: > I have a download into Excel with start and stop cells which contain the > date/time. I need help making my formula work please to get the NET > minutes. > > Please see my attached problem example. >