Using a macro you could parse the data, make the calculation and give
the result.
I think it would be easier for you to split the days and hours in 2
separate cells!


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=571017