June 25, 2016
Hi Expert,
I wanna calculate travel claim as below in excel.
i.e: i have mission to train at head office on 03 Sep 16 so i have to leave office on 02 Sep 16 at time 13:00pm.on 03 Sep 16 i leave head office to my work station at 17:00pm,arrive at 20:00 pm .how can i calculate in excel ?
criteria below:
Time out(depart)
-before or by 07:00am get breakfast 2$,lunch 4$ & dinner 4$
-before or by 12:00pm get only lunch 4$ & dinner 4$
-after 12:00pm get only dinner 4$
Time in(arrive )
-arrive by 12:00pm get breakfast 2$,lunch 0$ &dinner 0$
-before and by 17:00pm only breakfast 2$ & lunch 4$ dinner 0$
-after 17:00pm breakfast 2$,lunch 4$ & dinner 4$
note: overnight accomodation 15$ .
thanks in advance
VIP
Trusted Members
June 25, 2016
1 Guest(s)