Re: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format

2011-09-30 Thread John A. Smith
Thank you all very much for taking your time to teach others. I really appreciate your help. John On Thu, Sep 29, 2011 at 4:06 PM, dguillett1 wrote: > =(D2-C2)*24 > > *From:* John A. Smith > *Sent:* Thursday, September 29, 2011 2:55 PM > *To:* excel-macros@googlegroups.com > *Subject:

Re: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format

2011-09-29 Thread NOORAIN ANSARI
Dear John, For 7 Minute you can use..format =TEXT(I21-H21,"[h]:mm:ss") for number format use (I21-H21) and paste in Custom FOrmat [h]:mm:ss -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* <

Re: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format

2011-09-29 Thread B.N.Chethan kumar
(d2-c2)*24*60 ...change format to number Regards Chethan Kumar On Fri, Sep 30, 2011 at 1:36 AM, dguillett1 wrote: > =(D2-C2)*24 > > *From:* John A. Smith > *Sent:* Thursday, September 29, 2011 2:55 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Incremental Time Ca

Re: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format

2011-09-29 Thread dguillett1
=(D2-C2)*24 From: John A. Smith Sent: Thursday, September 29, 2011 2:55 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format Excel Experts, I need to calculate the time differences between 11:30:00 AM and 11:37:00 A