A
AKTribalAcct
I am trying to make a template that will calc per diem based on travel
schedule. We calc using lodging 00:00-06:00, and meals 06:00-12:00,
12:00-18:00, and 18:00-00:00. But I dont know how to calc based on time. EX:
If a cell says 08:00 than fill in the lodging amt. I realize a seperate chart
with current per diem rates and destinations would have to be filled in to
have data to pull from.
schedule. We calc using lodging 00:00-06:00, and meals 06:00-12:00,
12:00-18:00, and 18:00-00:00. But I dont know how to calc based on time. EX:
If a cell says 08:00 than fill in the lodging amt. I realize a seperate chart
with current per diem rates and destinations would have to be filled in to
have data to pull from.