Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula please
A B C D E
03/27/2007 11:49 03/27/2007 16:47 True 03/27/2007 21:30 03/27/2007 20:00 False I'm trying to find out the formula for column E. I want to determine if the date and time in column A+B is less than the date and time in Column C+D. Thank you in advance for your time and help. Deb |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula please
=A1+B1<C1+D1
"ferde" wrote: A B C D E 03/27/2007 11:49 03/27/2007 16:47 True 03/27/2007 21:30 03/27/2007 20:00 False I'm trying to find out the formula for column E. I want to determine if the date and time in column A+B is less than the date and time in Column C+D. Thank you in advance for your time and help. Deb |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula please
Thank you sooo much ... it works great . You saved me so much time.
Deb "Toppers" wrote: =A1+B1<C1+D1 "ferde" wrote: A B C D E 03/27/2007 11:49 03/27/2007 16:47 True 03/27/2007 21:30 03/27/2007 20:00 False I'm trying to find out the formula for column E. I want to determine if the date and time in column A+B is less than the date and time in Column C+D. Thank you in advance for your time and help. Deb |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula please
Sometimes one of the columns has no data entered, it may be missing the date
and time and so when I drag the formula down column E ....it will give me a value error. Is there a way for this cell to remain blank if there is no data to calculate?? "ferde" wrote: Thank you sooo much ... it works great . You saved me so much time. Deb "Toppers" wrote: =A1+B1<C1+D1 "ferde" wrote: A B C D E 03/27/2007 11:49 03/27/2007 16:47 True 03/27/2007 21:30 03/27/2007 20:00 False I'm trying to find out the formula for column E. I want to determine if the date and time in column A+B is less than the date and time in Column C+D. Thank you in advance for your time and help. Deb |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula please
=IF(AND(A1+B10,C1+D10),A1+B1<C1+D1,"")
"ferde" wrote: Sometimes one of the columns has no data entered, it may be missing the date and time and so when I drag the formula down column E ....it will give me a value error. Is there a way for this cell to remain blank if there is no data to calculate?? "ferde" wrote: Thank you sooo much ... it works great . You saved me so much time. Deb "Toppers" wrote: =A1+B1<C1+D1 "ferde" wrote: A B C D E 03/27/2007 11:49 03/27/2007 16:47 True 03/27/2007 21:30 03/27/2007 20:00 False I'm trying to find out the formula for column E. I want to determine if the date and time in column A+B is less than the date and time in Column C+D. Thank you in advance for your time and help. Deb |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula please
WORKS GREAT.... you are the man :)
"Toppers" wrote: =IF(AND(A1+B10,C1+D10),A1+B1<C1+D1,"") "ferde" wrote: Sometimes one of the columns has no data entered, it may be missing the date and time and so when I drag the formula down column E ....it will give me a value error. Is there a way for this cell to remain blank if there is no data to calculate?? "ferde" wrote: Thank you sooo much ... it works great . You saved me so much time. Deb "Toppers" wrote: =A1+B1<C1+D1 "ferde" wrote: A B C D E 03/27/2007 11:49 03/27/2007 16:47 True 03/27/2007 21:30 03/27/2007 20:00 False I'm trying to find out the formula for column E. I want to determine if the date and time in column A+B is less than the date and time in Column C+D. Thank you in advance for your time and help. Deb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|