Greetings:

I need a bit of help. I think I may be making my life much more
complicated than I need. I have this data:


Code:
--------------------

Date TimeIn1 TimeOut1 TimeIn2 TimeOut2
01/01/2006 06:00 11:00 15:00 19:00
01/02/2006 20:00 02:00
01/03/2006 23:00 09:00
01/04/2006 06:00 19:00

--------------------

What I need to do is develop two functions. The first I have but it
seems more complex than it needs to be. It is to get the number of
hours worked. It got uglier than it should be in the "wraparound"
times such as is shown in 01/03/2006.

The second function is the one that's causing me fits. I need to get
the number of hours outside of the window 08:00 - 17:00. In
01/01/2006, I have a total of 9 hours. The hours 06:00-08:00 and
17:00-19:00 are outside of this window, so I would return 4.0 hours.
Again, the complexity that is just irritating me is the wraparound
hours.

It should not be as difficult as I am making it. I seem to have
started down a path and am stuck in the rut now. I can't break free to
get the obvious answer that I need.

Any help will be greatly appreciated!

Thanks!


--
cm_gmail
------------------------------------------------------------------------
cm_gmail's Profile: http://www.excelforum.com/member.php...o&userid=33451
View this thread: http://www.excelforum.com/showthread...hreadid=532590