No problem, here we go:

Start Monday 2/23/2009 18:10; End Tuesday 2/24/2009 06:30; 13 hours 20
minutes non-working weekday (M-F) time

Start Thursday 2/12/2009 09:34; End Thursday 2/12/2009 15:29; 5 hours 55
minutes working weekday (M-F) time

Start Wednesday 2/11/2009 23:39; End Thursday 2/12/2009 06:30; 6 hours 51
minutes working weekday (M-F) time

Start Saturday 2/7/2009 15:21; End Monday 2/9/2009 06:30; 39 hours 9 minutes
non-working weekend time

Again, the department I'm working with has normal business hours M-F 06:30
to 15:30.

Thanks again,
Mike


"Fred Smith" wrote:

No. Most people don't like to open files because of the risk of viruses. If
you absolutely have to have someone look at the file, then upload it to a
file hosting website (there are many), then post the link. But don't be
surprised if people don't open the file.

Just show a sample of what you need done. How difficult is it to give a few
examples? Something like:
Start Saturday at 07:00, end Saturday as 12:00 is 5 hours time worked.
Start Saturday at 13:00, end Sunday at 15:00 is ? hours time worked.
Start Sunday at 14:00, end Monday at 12:00 is ? hours time worked.

Only you know what situations you need to handle, and what result you want.

Regards,
Fred.

"watermt" wrote in message
...
Would you like me to email you a sample file? If so, let me know how I
can
get that to you?

Mike

"Fred Smith" wrote:

Give us an example of your data (the start and end date/times), and the
result you want to see. What happens if you start outside of working
hours,
but finish inside? You'll need to decide on what your definition of
"working
hours" is.

Regards,
Fred.

"watermt" wrote in message
...
=IF(OR(D41="",F41=""),0,(NETWORKDAYS(D41,F41)-1)*("15:00"-"06:30")+MOD(F41,1)-MOD(D41,1))

Im trying to calculate the non-working time accumulated by a process
outside the normal shift of M-F 0630-1500 timeframe. But if all the
work
is
done on a non-working day (Saturday or Sunday) I get the negative dates
or
time symbol ########, or in some cases hours after or before the time
above
for M-F. Ive checked the dates and theyre correct.

Can someone explain possibly other reasons why this may be occurring?

Mike