Date and time

[Victor tango]

Hi all

I'm new to the world of excel and need some assistance, if any one can help.

I am creating a log book and in my first column (column B), I have it ste in date format and my dates inserted ie(01/01/2014)

I also have column I and J set in Time format, and am inserting time of the day, but these colums also display the date which is set to (01/01/1900). can this be changed using a formula to equal column B?

Thanks

 

[VBA Geek]

If you just want to show the time then select the values, press CTRL F1 or CTRL 1, to go to formatting, then in the tab time you may choose your desired format