excel2003餐費計算 - 工作
By Tristan Cohan
at 2011-10-22T00:00
at 2011-10-22T00:00
Table of Contents
請問有高手可以當我解決依下問題嗎?我想用EXCEL算出員工每日誤餐費與津貼例:早班上班時間08:30下班時間17:00加班超過18:30有1餐超過24:00加一餐※第1餐計算的出來.但是第2餐有跨日就算不出來囉=ˇ=夜班上班時間20:30下班時間05:00加班超過24:00有1餐超過07:00加一餐※第2餐可以計算出來.但是第1餐也是算不出來ˊˇˋ麻煩好心人幫我解答一下~THANKS!圖片參考:http://imgcld.yimg.com/8/AB07120350/o/1611102204......Showmore
Tags:
工作
All Comments
By Delia
at 2011-10-26T03:15
at 2011-10-26T03:15
By Catherine
at 2011-10-24T22:47
at 2011-10-24T22:47
By Kumar
at 2011-10-26T16:11
at 2011-10-26T16:11
Related Posts
星巴克計時人員
By Christine
at 2011-10-22T00:00
at 2011-10-22T00:00
我哥他女友太過份了,我該如何做?
By Jake
at 2011-10-22T00:00
at 2011-10-22T00:00
如何申請低收補助資格
By Enid
at 2011-10-22T00:00
at 2011-10-22T00:00
懇求車禍過失致死賠償建議
By Catherine
at 2011-10-22T00:00
at 2011-10-22T00:00
求職轉職之豪宅社區秘書
By Olive
at 2011-10-22T00:00
at 2011-10-22T00:00