If statement involsing time hr:min:s

January 7, 2011 at 02:51:59
Specs: Windows XP
Hi guys,

Im trying to write a formula to identify the type of transaction based on the time it happened.
Breakfast 11:00:00
Lunch 11:00:01 15:30:00
Late Meals 15:30:01 24:00:00

Can someone help?

thanks


See More: If statement involsing time hr:min:s

Report •

#1
January 7, 2011 at 06:35:36
Your question is not clear, at least not to me.

What is the criteria? Do you have a time in a cell someplace that you are checking to see what happened at that time? Do you have an event in a cell someplace and you are trying to determine when it happened? Something else?

Please clarify what you are trying to do, perhaps by providing an example of a situation with both the input and the desired output.

Please read the How To referenced in my signature line before posting examples of your data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 8, 2011 at 14:35:24
Hi,

Thanks for the reply. the critaria is that i have sales transactions that i want to split between for the time it happend i.e breakfast lunch or dinner. For eg the data is presented as
01.01.11 - 07:30:00 - till 1- bob smith - £2.50
and i want to sort out the data based on date and/or time it happend so that i can identify the sales per service time.

thanks


Report •

#3
January 8, 2011 at 18:52:11
Well, that didn't clear up anything for me.

re: "i have sales transactions that i want to split between for the time it happend"

I don't know if we have a language issue here, but the grammar in that statement makes no sense.

As I said in my previous response, please read the How To referenced in my signature line then post some examples of your data with Column letters and Row numbers.

Once you have shown us what you data looks like, give us an example of what the desired results should be - using the data, not just words.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question