It won't be a true time value, but you can get the appearance by formatting
cell:
0":00"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Hezzy" wrote:

How do it enter in a single digit for time but have it displayed at full
time. For example if I type in the number 8 how to I get it to display 8:00?