Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Question
Hi,
I have a column with times in it 11:28:46 AM 11:29:21 AM 11:29:50 AM 11:44:03 AM 11:44:10 AM 11:44:25 AM & would like to add the value Lunch or Dinner depending on wether the time is between say 9:00:00 AM and 2:00:00 PM for Lunch & 2:00:01 PM and 11:59:59 PM thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Question
Check if the picture answers your question:
http://img32.imageshack.us/img32/8118/nonameme.png Micky "Tango" wrote: Hi, I have a column with times in it 11:28:46 AM 11:29:21 AM 11:29:50 AM 11:44:03 AM 11:44:10 AM 11:44:25 AM & would like to add the value Lunch or Dinner depending on wether the time is between say 9:00:00 AM and 2:00:00 PM for Lunch & 2:00:01 PM and 11:59:59 PM thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Question
You could use an "IF" statement. Suppose cell A2 has the time in it:
=IF((A2TIME(9,0,0))*(A2<=TIME(14,0,0)),"lunch","D inner") "Tango" wrote: Hi, I have a column with times in it 11:28:46 AM 11:29:21 AM 11:29:50 AM 11:44:03 AM 11:44:10 AM 11:44:25 AM & would like to add the value Lunch or Dinner depending on wether the time is between say 9:00:00 AM and 2:00:00 PM for Lunch & 2:00:01 PM and 11:59:59 PM thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
VBA Question / | Excel Worksheet Functions |