加班時數函數設定:－2014星座運勢大預言, 唐立淇2014星座運勢, 2014星座運勢處女座, 2014星座運勢雙魚座, 2014星座運勢天秤座, 薇薇安2014星座運勢

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 社會人文 - 發問中

加班時數函數設定

Jun 26th 2013, 07:08

請問當加班>172H至214H時，要時數*1.66，

A欄為實際上班時數 173H 180H 210H 214H 215H
B欄為>172H,<=214H
C欄為>214H

例如實際上班173H,超過172H,其加班時數為1H*1.33=1.33,以此類推

請問公式要怎麼設定才會自行總計超過172H,214H以下的時數統計呢?

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. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html

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