Need Help with Logical Statements

[DOCDIVA]

Hello-
I have roughly 300,000 rows. One of the columns is AM or PM for 12 hour time period. I want to check that is the column says AM to replace with 0. If the column value says PM, I want 720 to be placed

The formula I have is =IF (Cell location = AM, 0, 720) but it keeps coming up with #NAME? . . . Please assist! I don't have much experience with logical functions so IF could be the wrong formula or I could have made a mistake

I did expand the dada using the text to column function but do not know how this would hurt this formula if does not have issues

PLESAE HELP!

 

[jeffreybrown]

Hello & Welcome to the Forum,

If the cell literary has "AM" or "PM", try...

=IF(A1="AM",0,IF(A1="PM",720,""))

 

[FDibbins]

What exactly are you trying to do here?
What did the original data look like?

 

[DOCDIVA]

Thank you so much, Jeff!!

Ford - I am comparing efficiency by breaking time into minutes. These are all DB records, so it's frustrating to work with

 

[FDibbins]

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

So you could probably do what you want, working directly on the data itself

 

[DOCDIVA]

If anyone can think of another solution, I have one more issue. I have dates in the format of (MM/DD/YYYY) and further columns with time broken out into minutes. I want to compare dates. Column A = Submitted Date, B= Submitted Time in minutes, C= Resolved Date, D= Resolved Time in Minutes, E= Day difference between Submitted and Resolved dates, F = number of minutes for amount of days in between . . . for instance:

12/01/2012 287 12/01/2012 287 0 0 -> Want this to return 0
12/01/2012 485 12/01/2012 501 0 0 -> Want this to return 16
12/05/2012 116 12/06/2012 220 1 1440 -> Want this to return 1542 (1440 for the full day, plus the 104 for the other part)
12/05/2012 100 12/06/2012 90 1 1440 -> Want this to return 1430 (1440 - 10 for the incomplete day)


Any ideas??

 

[FDibbins]

Did you see my last post?

What does your raw data look like?

 

[joeu2004]

column a = submitted date, b= submitted time in minutes, c= resolved date, d= resolved time in minutes, e= day difference between submitted and resolved dates, f = number of minutes for amount of days in between . . . For instance:
12/01/2012 287 12/01/2012 287 0 0 -> want this to return 0
12/01/2012 485 12/01/2012 501 0 0 -> want this to return 16
12/05/2012 116 12/06/2012 220 1 1440 -> want this to return 1542 [sic; should be 1544] [...]
12/05/2012 100 12/06/2012 90 1 1440 -> want this to return 1430

e2: =c2-a2
f2: =e2*1440+d2-b2
or
f2: =(c2-a2)*1440+d2-b2