Try formatting all those cells as: [h]:mm

I'm betting that you'll see that the data isn't what you think it is.

changetires wrote:

That returned a result of 80:00 when it should have been 32:00

tks,

Ed

--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=557010

--

Dave Peterson