close
Blogtrottr
Mobile01最新文章
 
Kindle Book Deals

We find the best deals on best-selling Kindle books for you. Just tell us which genres you love and we'll do the rest. The best part? It's completely free!
From our sponsors
求excel薪水計算方式
May 6th 2014, 10:54

想請問大家若要編排與計算會採用哪種作法，怎麼做?
我只會最精簡的，但做的二二六六的，請教教我!!
我的作法是：
下午-上午=上班時數
計算實數=IF(MINUTE(上班時數)>=30,HOUR(上班時數)&":30",HOUR(上班時數)&":00")
計算值==HOUR(計算實數)+MINUTE(計算實數)/60&""
這兩個是爬文來的，我的解讀是：
計算實數--->上班時數的分滿30，上班時數的小時：30,上班時數的小時：30
計算值----->就是把上班時數的：30變0．５
不知道這樣解讀法對不對！！
加班時數＝計算值－８，如果是負值要怎麼自動帶入為０？？
加班費＝超時加班時薪＊單位時薪＊１．３３，如果是負值要怎麼自動帶入為０？？
ｐｓ：勞基法是規定每天加班1~2小時1.33倍
　　　勞基法是規定每天加班3~4小時1.67倍
　　　勞基法是規定每天加班5小時以上2倍
　　　假日加班(8小時以內)~~给一天薪水~~
　　　超過八小時再以上述時間計算加班~~
在７／９那天加班７。５小時，要怎麼運算比較好？？
每日薪水＝加班費＋時薪
不好意思，太多問題了，就請大家幫幫我>"

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.
You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions
arrow
arrow
    全站熱搜

    kahntoue 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄