hi
i have a spreadsheet containing days and times a fault occurred on a
machine
the faults can occurr any time over a 24 hr period
what i want to do is
on a saturday stop the count after 18:00:00
and on a sunday start the count at 06:00:00
if the fault runs through the saturday and sunday i want to ignore
18:00:00 to 06:00:00
the column holding the start day is CN
the column holding the start time is CP
the column holding the End time is CS
the column holding the End day is CT

Start day Start time End time End
day Total down time
Saturday 08:30:00 17:30:00
Saturday 9:00:00
Saturday 08:30:00 19:30:00
Saturday 9:30:00
Saturday 07:30:00 04:30:00
Sunday 0:30:00
Saturday 17:30:00 08:30:00
Sunday 3:00:00
Sunday 05:30:00 08:30:00
Sunday 2:00:00

thanks for any help

kevin