Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculations with date time interval
I have a date time value in a cell
It appears in cell as "1/1/04 18:00 In formula bar it appears as " 1/1/2004 6:00:55 PM I need to do calcs on this in excel - if date is = " another date I try toi enter" then good, bad not having any luck thanks for your time. |
#2
|
|||
|
|||
=IF(INT(that_date)=another_date,"good","bad")
-- HTH Bob Phillips "Todd F." wrote in message ... I have a date time value in a cell It appears in cell as "1/1/04 18:00 In formula bar it appears as " 1/1/2004 6:00:55 PM I need to do calcs on this in excel - if date is = " another date I try toi enter" then good, bad not having any luck thanks for your time. |
#3
|
|||
|
|||
Make sure your IF() is O.K.
Example A1 is 9/22/2005 13:18 B1 is 9/22/2005 19:20 C1 has =IF(B1=A1,1,2) and returns 1 -- Gary''s Student "Todd F." wrote: I have a date time value in a cell It appears in cell as "1/1/04 18:00 In formula bar it appears as " 1/1/2004 6:00:55 PM I need to do calcs on this in excel - if date is = " another date I try toi enter" then good, bad not having any luck thanks for your time. |
#4
|
|||
|
|||
On Thu, 22 Sep 2005 09:56:02 -0700, "Todd F."
wrote: I have a date time value in a cell It appears in cell as "1/1/04 18:00 In formula bar it appears as " 1/1/2004 6:00:55 PM I need to do calcs on this in excel - if date is = " another date I try toi enter" then good, bad not having any luck thanks for your time. Assume your date is in A1 and the date you are comparing it to is in A2 and is just a date (i.e. -- no time portion). =IF(INT(A1)A2,"good","bad") --ron |
#5
|
|||
|
|||
thanks I got it to work as well but not in the if box - just straight in the
cell "Gary''s Student" wrote: Make sure your IF() is O.K. Example A1 is 9/22/2005 13:18 B1 is 9/22/2005 19:20 C1 has =IF(B1=A1,1,2) and returns 1 -- Gary''s Student "Todd F." wrote: I have a date time value in a cell It appears in cell as "1/1/04 18:00 In formula bar it appears as " 1/1/2004 6:00:55 PM I need to do calcs on this in excel - if date is = " another date I try toi enter" then good, bad not having any luck thanks for your time. |
#6
|
|||
|
|||
thanks now I am going to try an nested if
"Bob Phillips" wrote: =IF(INT(that_date)=another_date,"good","bad") -- HTH Bob Phillips "Todd F." wrote in message ... I have a date time value in a cell It appears in cell as "1/1/04 18:00 In formula bar it appears as " 1/1/2004 6:00:55 PM I need to do calcs on this in excel - if date is = " another date I try toi enter" then good, bad not having any luck thanks for your time. |
#7
|
|||
|
|||
thanks
"Ron Rosenfeld" wrote: On Thu, 22 Sep 2005 09:56:02 -0700, "Todd F." wrote: I have a date time value in a cell It appears in cell as "1/1/04 18:00 In formula bar it appears as " 1/1/2004 6:00:55 PM I need to do calcs on this in excel - if date is = " another date I try toi enter" then good, bad not having any luck thanks for your time. Assume your date is in A1 and the date you are comparing it to is in A2 and is just a date (i.e. -- no time portion). =IF(INT(A1)A2,"good","bad") --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
Date & Time problem | Excel Worksheet Functions | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
putting date and time together in 1 cell | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel |