Date and time difference
 

Hi,

I am looking for a formula that works out the time difference, in days,
hours and minutes between 2 cells (each cell containting this info: ddmmyyyy
hhmmss). This has to take into account the working hours being 8 - 6 and
must not include weekends.

Any ideas gratefully accepted.

Date and time difference
 

Hi

Have a look at this page from Chip's site:
http://www.cpearson.com/excel/DateTimeWS.htm#WorkHours

Hope this helps.
Andy.

"Danieljesse" wrote in message
...
Hi,

I am looking for a formula that works out the time difference, in days,
hours and minutes between 2 cells (each cell containting this info:
ddmmyyyy
hhmmss). This has to take into account the working hours being 8 - 6 and
must not include weekends.

Any ideas gratefully accepted.