Spanners, I think JFE117 has got the idea - and he posted while I was looking at some spreadsheets I did.
However, I think if you go to Format/Cells and look at TIME you might find that the instructions you gave are 'bad data' 'cos you are 'asking' it to go BACK to 02:00 after having given it 22:10 or whatever. You do, therefore, need to IF the next day with a date, and the time. The cell format does in fact allow for that.
Hope that right.