Thanks for pointing it out..

It is in M/D/Y format. Let us have the dates as 4th & 5th of April in
2005. In this case, the hours will be 13.5 totally (7 hrs in 4th & 6.5
hrs in 5th).


--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile: http://www.excelforum.com/member.php...o&userid=15705
View this thread: http://www.excelforum.com/showthread...hreadid=535417