Friday, February 09, 2007 8:57 pm
Work is getting more & more fun..n will always be..=D
Today @ work get to do new stuff..so happy!!haha..u will think i am siaoz..but the feeling of getting to learn sth new was so..to the extend tt no word on earth could be used to describe it..
This past few days i have been rather 'kong xian' in the office..not much things for me to do cause alot of things is quite new to me n tt it needs some complicated calculation..so..all those things have been left to xin xian ..my first day @ work was just stamping..boring but quite fun...Following few days was considered to be improvement cause xin xian teach me how to record the overseas trip proposals into the Excel,which i am a truly idiot in tt..haha..but everything came out quite fine..=)
Today did something much much more complicated..maybe to me..got to do per diem..the per diem thingy need some complicated calculation..let me tell u how..
1)First u have to look @ the itinerary ang record on the excel the person name,trip,duration..
2)next u have to see when they arrive n depart in the disignated location...
3)u have to put in the time n they will be calculated using some 'dont-know-wat' math..
4)next u have to see the final timing in which they took how many hour..
5)if the hour have some decimal place which is between 0.3333 to 0.6667, u will need to times it by the full rate of tt country n multiply it by 18%.
6)if it is less than 0.3333, den just ignore it..
7)if it is more than 0.6667, add 1 more day to the rest of it
8)Finally,the adding n multiplying process will get u an number..
9)tt is the per diem!!
P.S:sometimes they will take more than 1 flight to reach their designated place..so u have to calculate the transit timing..