How should the formula read to check the TIME value of a certain cell for 12:00 PM?
If the TIME in the referenced cell is 12:00 PM...return NOON.
Here is what I have...and it doesn't work:
=IF(DATA!C12="","",IF(DATA!C12=(TIME(12,0,0)),"NOON",DATA!C12))
Last edited by HuskerBronco; 12-14-2008 at 06:19 PM.
That formula should work assuming Data!C12 contains just a time.
What's in C12, is it generated by a formula?
When I select the cell, this is what shows in the formula bar:What's in C12, is it generated by a formula?
The cell (C12) is TIME formatted, and the time entered comes from a drop-down list containing all times from 10:00 AM to 11:00 PM...incremented every 30 minutes.12:00:00 PM
The NAMED RANGE that the drop-down list comes from DID contain formulas...but I overwrote them with TIME values...and it still didn't work.
Format C12 as General and what do you see?
Entia non sunt multiplicanda sine necessitate
In the formula bar... 0.499999998666667Format C12 as General and what do you see?
And...it still says 12:00 PM in the target cell. (Not NOON)
Well -- that's not noon.
You could use DLL's suggestion, or fix the drop-down ...
Excel sometimes behaves oddly when you increment times like that. I can't replicate the specific problem, though. What formula did you use to increase the time by 30 minutes?
Try using this version
=IF(TEXT(DATA!C12,"h:mm")="12:00","NOON",DATA!C12)
I just tried your formula and it worked for me. You said that "... it doesn't work ..." so what do you see instead of "NOON"? Also, if the time in C12 is supposedly 12:00:00 and you temporarily change the cell format to numeric is it 0.50000? If you change the formula to:
what does it display?=IF(DATA!C12="","",IF(DATA!C12=0.5,"NOON",DATA!C12))
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks