Another useful trick to remember is that if you format a cell as hh:mm:ss or something similar, then that is what is displayed, even if the cell contains a full date and time. (In fact all date/time cells contain a full date and time, starting from 1900/01/01)
So you can hold full date/time in cells but only display the time portion.