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

2011-09-30 Thread John A. Smith
.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 > AM and show the 7 minutes in the decimal hour format. > > Please see atta

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
$ 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 > AM and show the 7 minutes in the decimal hour format. > > Please see attached sample spreadsheet for the solution

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

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

2011-09-29 Thread John A. Smith
Excel Experts, I need to calculate the time differences between 11:30:00 AM and 11:37:00 AM and show the 7 minutes in the decimal hour format. Please see attached sample spreadsheet for the solution I need. Thank you for your continuing Excel help. John --