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.
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.
It worked except the return box returned the total per diem it did not subtract the dinner amount. I did not see if I typed in a arrival time in any of the other cells if the same error occurred. I highlighted the cell in red and typed the correct amount that it should have calculated.
Thanks again for all of your help.error per diem.xls
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
tsh1586 
Register To Reply
Bookmarks