Формула за калкулацију радног времена

31/03/2011 § Leave a comment

Калкулација колико времена проводите на послу током дана.

LowBound= 09:00, UpperBound=17.00 – Радно време за смену

CheckIn и CheckOut – Време доласка и одласка са посла

= IF(CheckOut>CheckIn,MAX(0,MIN(CheckOut,UpperBound)-MAX(CheckIn,LowBound)), MAX(0,UpperBound-MAX(CheckIn,LowBound))+MAX(0,MIN(CheckOut,UpperBound)-LowBound))


Excel Page

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What’s this?

You are currently reading Формула за калкулацију радног времена at RheXenoR.

meta

%d bloggers like this: