software

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.

Hi

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

Hope this helps.
Andy.

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