You need to checK what your cells contain

if 05:00 is 5 hours no minutes it can be changed to 05:00:00 by
formating as hh:mm:ss

If it is mm:ss and you wish it to be hh:mm:ss eg your minutes should be
hours and seconds should be minutes multiply it by 60 and format as
hh:mm:ss

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=553517