Forum

Notifications
Clear all

Travel claim

4 Posts
2 Users
0 Reactions
152 Views
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

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

 
Posted : 07/09/2016 12:32 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi rathanak

See if this is what you want.

 
Posted : 07/09/2016 2:31 am
(@rathanak)
Posts: 55
Trusted Member
Topic starter
 

Thanks Sunny,it is correct like my manual calculation

You really genius wish you good health n success in your walk of life

 
Posted : 07/09/2016 11:20 am
(@sunnykow)
Posts: 1417
Noble Member
 

Glad it helps. Cool

Sunny

 
Posted : 07/09/2016 11:22 am
Share: