Converting Wrong Time Value to Correct One
 

You could use another column to convert....

If your "times" are in column A then in B1

=IF(A1<1,A1,TEXT(A1,"00\:00")+0)

format as hh:mm

copy down column

note: this should return the time if A1 contains just a time or convert
otherwise


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508796