Date and time difference

[Danieljesse]

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.

 

[Guest]

Hi

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

Hope this helps.
Andy.