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

2011-06-17 Thread Anil Bhange
] 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.. =IFERROR(ROUND(VALUE(HOUR(D18)+(MINUTE(D18)/60)),1),) -- Thanks

$$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

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 johnasmit...@gmail.comwrote: Dear Excel Teachers, I need a formula to give me the decimal hours between two