multiple criteria for calculations

I am looking at this and its honestly not making much sense to me. With my current understanding if my departure is at 10am and my arrival is at 8pm. You are going to charge my lunch twice. Please upload an example of all possible scenarios and the results it would look like.

An example would be better. Can you upload a sheet with data on it so that I can see it?

I see the times are on different lines now. Okay. Let me work with what i know now and see what i can come up with.

Lets make sure I am doing this right.
Example 1- If the customer departs at 5:00am they received full reimbursement and if out of state they would received $45 or would they receive $20 since we are talking about departing?
Example 2- If the customer departs after 6:00am but before 11:00am then the receive partial reimbursement from not eating lunch but charged for breakfast because it was available to eat during the time of their stay and out of state again the per deim would just be lunch of $12.00?
Example 3- If the customer departs after 11:00am they receive no reimbursement at all?

Am I correct?

If I was correct then I believe this will work for you however I believe i over thought to formula to calculate the meals provided so that the formula adjusts the per diem without having to put how many meals were provided. Let me know what you think.

I apologize. My understanding of what you desire is unclear at this point.

In the first post you asked that column W calculate based on whether or not column V has a P or not but you already have that calculation in place with the IF function yourself. IF V = "P" then, multiply full per fiem amount column T by .75, if not then its the full amount. Then you explained how the amounts would work if P based on departure time and arrival time. I presumed you wanted the formula to then figure out what the amount should be based on whether column V was P or not and based on the times was inputed. But in the post above this you mentioned column V would be manually entered in. I am confused as to why its necessary for me to understand the time at all then if the P will be manual and you already have a formula that works for what you want in column W.

If anyone else can help please do.

Here is what i thought you wanted. I thought you wanted to automatically calculate the sheet as much as possible. The facts required by a user was the date, from, to, departure time, arrival time, in or out of state. Based on that information the spreadsheet could then calculated based on understanding the time facts of breakfast, lunch, and dinner it would then autocalculate the full per diem rate, whether or not it was partial or full, and the per diem amount. This elminates the need to put P or F and the need to put in how many meals are provided. If this is not what you want then the spreadsheet you uploaded works for what you are asking for to the best of my understanding at this point.

I sent you a pm check it please. Need to iron out some details.

Okay. Try this. Yellow cells needed data and grey cells are autocalculated. You can change colors later when sheets is finished if you desire.

Try the scenario you posed in your example and see if the results are correct.

If its not there may be an issue with a formula. Save it with the error and below replace the grey cells with what the desired results should be and i will make it happen.

I noticed another small issue as well and fixed it too. Those nesting formulas can get complex quick.

I had the wrong cells referenced. Keep checking to make sure the results are all correct. Try all three different times departure and arrival.

If you find that it doesn't work for a certain one then let me know and I will fix that. I will keep the subscription to this thread on for a bit just in case. Thank you for the rep. I appreciate it much. Also don't forget to mark your thread solved unless you are waiting to make sure it works with everything that is.