RE: $$Excel-Macros$$ Formula to Calculate Hours Between Dates

2011-06-17 Thread Anil Bhange
xcel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Thursday, June 16, 2011 11:06 PM To: excel-macros@googlegroups.com Cc: John A. Smith Subject: Re: $$Excel-Macros$$ Formula to Calculate Hours Between Dates Dear John, Please try it.. =

Re: $$Excel-Macros$$ Formula to Calculate Hours Between Dates

2011-06-16 Thread NOORAIN ANSARI
Dear John, Please try it.. =IFERROR(ROUND(VALUE(HOUR(D18)+(MINUTE(D18)/60)),1),"") -- Thanks & regards, Noorain Ansari On Thu, Jun 16, 2011 at 8:05 PM, John A. Smith wrote: > Dear Excel Teachers, > > I need a formula to give me the decimal hours between two dates. I have > at

$$Excel-Macros$$ Formula to Calculate Hours Between Dates

2011-06-16 Thread John A. Smith
Dear Excel Teachers, I need a formula to give me the decimal hours between two dates. I have attached a sample. Thanking you in advance for your on-going help and wisdom. John -- -- Some important links for excel