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