I am using MS Office 2003. I have tried to enter just time into a cell (example 01:13:59) but I have only been able to enter both date and time when the format is set to Time. I am now trying to set the Format to Text (or another Format that will work) and write a VB Macro to place colons ( between the 8 digits. Can anyone help please.

I hope I have given enough information. just joined.

Thanks for your help.

Dave