hi Wizz....i read the help on timevalue, but I really don't know how to use it....as for the cell formatting, it is already formatted as time.