Trying to come up with a formula that will calculate the following.

column A has the following format mm/dd/yy hh:mm am

what i want to do is in column B is have an "if" statement that will
give a return based on certain time paramiters. If I break out column A
using column to text I can do it, I 'm wondering if there's a way to do
it without using that.

Dates are diff down the list

Thanks for all responses


--
justmeisall
------------------------------------------------------------------------
justmeisall's Profile: http://www.excelforum.com/member.php...o&userid=16351
View this thread: http://www.excelforum.com/showthread...hreadid=277380

Hi
to get the time part use
=MOD(A1,1)
and format as time

"justmeisall" wrote:


Trying to come up with a formula that will calculate the following.

column A has the following format mm/dd/yy hh:mm am

what i want to do is in column B is have an "if" statement that will
give a return based on certain time paramiters. If I break out column A
using column to text I can do it, I 'm wondering if there's a way to do
it without using that.

Dates are diff down the list

Thanks for all responses


--
justmeisall
------------------------------------------------------------------------
justmeisall's Profile: http://www.excelforum.com/member.php...o&userid=16351
View this thread: http://www.excelforum.com/showthread...hreadid=277380