Diff. in time
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 |
All times are GMT +1. The time now is 07:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com