Im using an Excel 2003 & i need to calculate the net process or respond time excluding
1. weekends &
2. non working hours
My excel sheets contains:-
A2:- Start date
B2:- Start time
C2:- Stop date
D2:- Stop time
E2:- needs to show the difference of the time in minutes
(If required, the start date & time can be combined to one cell)
Working hours will be:-
Monday to Friday:- 06:30 to 22:00 hrs (IST)
Saturday 09:30 to 13:00 hrs (IST)
Weekends with be:-
Saturdays (After 13:00 hrs) + Sundays (Whole day) + Monday 06:30 hrs
Plse help me out whether there is any possibilities to set up such formula in excel 2003.
This will reduce lots of work from my end
Bookmarks