Formula – Kalkulacija radnog vremena

22/06/2013 § 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))


Source: http://puremis.net/excel/MastersText/text_Daniel.shtml

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 Formula – Kalkulacija radnog vremena at RheXenoR.

meta

%d bloggers like this: