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.
Last edited by Jack7774; 04-30-2014 at 12:28 PM. Reason: spelling correction
Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
This didn't work. They will fill in full or partial (F or P field) I need the formula to look at that field and if P is provided then it will calculate based on the time left or arrived. Does that make sense?
For example if I left on 05/01 at 11:30 AM I would put a P in the V column in the first row. The formula will then look to see if it is in-state or out of state. A 1 or 2 in U column. Based on these two columns and the time departed or left it will deduct the correct amount.
So if I was traveling in state according to the per diem breakdown at the bottom of sheet the total day is 35.00 if I leave at 11:30 AM it will take 35.00 and deduct 15.00 (6.00 breakfast, 9.00 for lunch) so the total per diem should say 20.00.
Does this help?
I am reattaching my worksheet I tweaked a littletravel reimbursment form.xls
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks