Hello again,
I recently posted a challenge and got some great VBa responses, however I can not use Macros in my spreadsheets. Also, I figured out a better way to ask my question and I think I am getting closer.

Given a work day of 7:00am to 7:00pm
Given a work week of Monday thru Saturday
can the following be done in excel:

Date/time
11/3/2012 5:00pm

+ 6 (hours)

= 11/4/2012 11:00am

Thanks in advance...