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
Hi,
I am looking for a formula that would extract hours and minutes. I want it
to ignore the date and seconds and not round the minutes based on the
seconds. Preferably wither in military time or with AM?PM so that it can be
sortable. Here is the way the data is currently formatted.
This
