daddylonglegs Wrote:
OK, that's quite feasible, I think,but not with the previous formulas I
suggested :( Those assumed you were only looking at full days.

Will your times/dates in C22 and C23 always be within working hours,
e.g. Saturday to Wednesday 09:00 to 18:00?

What's the longest period you're likely to have to measure?

What result would you expect where

C22 = 25/04/2006 10:14 AM and
C23 = 26/04/2006 10:00 AM?

Thanks,
Attached Excel file to explain the required


--
migdad
------------------------------------------------------------------------
migdad's Profile: http://www.excelforum.com/member.php...o&userid=33976
View this thread: http://www.excelforum.com/showthread...hreadid=537502