Good day.
I have 2 dates say Datein- In Cell A1 and Dateout-In Cell A2.
I want to calculate number of hours and minutes between these two date
taking care of these two
factors.
1) Number of working hours-8
2) Weekends to be excluded (Thursday and Friday)
Please help

--
Message posted from http://www.ExcelForum.com

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

--
Regards
Frank Kabel
Frankfurt, Germany

"depks >" <<(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
> Good day.
> I have 2 dates say Datein- In Cell A1 and Dateout-In Cell A2.
> I want to calculate number of hours and minutes between these two
dates
> taking care of these two
> factors.
> 1) Number of working hours-8
> 2) Weekends to be excluded (Thursday and Friday)
> Please help.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>