You don't need a formula. You should just be able to format the cell as
time.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Porous Metals Limited"
wrote in message ...
what is the formula for converting a time from 14.58 to read 2:35 pm?