You could input the hour in one column and the minutes in another column and then combine them in a third column (e.g. hour in B1; minute in C1, time = B1&":"&C1). I was surprised to find that I did not need to copy/paste special>values in order to calculate the difference between 2 values in the final time column.