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