Help with Date/Time Function

[Smonczka]

I am working with date/time functions trying to figure out how many
hours were spent doing a job. I have a start time and a finish time.

But I need to subtract out any time between five pm and six am and
weekends from the times. These would be times that no one was actually

working on the job. For example I have

4/5/2005 18:23 4/6/2005 17:04

Could someone give me a clue as to how this might be done?

Thanks,
Steve Monczka
(e-mail address removed)

 

[Peo Sjoblom]

It's not a trivial thing, here's an example

http://www.cpearson.com/excel/DateTimeWS.htm


or here

http://tinyurl.com/cbphn

 

[Smonczka]

Thank you Peo, that did what I needed.