r you can.” - John Wesley
-
From: Bill Q
To: excel-macros@googlegroups.com
Sent: Mon, November 19, 2012 9:54:25 AM
Subject: Re: $$Excel-Macros$$ Looking for formula to extract hours and minutes
Paul,
Your explanation was clear and insightf
00
>
> hope this helps.
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
>
e places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Bill Q
To: excel-macros@googlegroups.com
Sent: Fri, November 16, 2012 12:17:53 PM
Subject: Re: $$
Hi Sam,
Thanks for the advice. Yes, I had tried that. Yes, it visually changes it
to what I want, but again - the "true" time still indicates seconds in
addition to the hours and minuites. Under normal circumstances this may not
be an issue, however I am using a vlookup formula afterwards for
