Sveta

This might take some explaining since I get the feeling Excel and you
have just met.

First thing: Handling time in Excel is a bit tricky, but not
impossible. All the cells you are going to be using with times in them
need to be formatted in the following Custom format [hh]:mm You can get
to this either by pulling down Format tab and selecting the cell or by
pressing Ctrl and 1 together.

Take a look at the attached excel file (I hope you know how to unzip
files!) - the gree cells can be filled in, the yellow cells are output
cells- take a look at the formulae in them to see how it compares the
time worked against the maximum allowable. The formula below compares
the time worked against the max (in cell B11), if the time worked is
less than the maximum, the answer is Nil, if not, then it subtracts one
from the other and carries this into the mext month

=IF(D13<$B$11,0,D13-$B$11)

Good luck !


+-------------------------------------------------------------------+
|Filename: svetlana's help.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3722 |
+-------------------------------------------------------------------+

--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=398089