Urgent help please

I have been working on a excel sheet, is there any way that we can add a formulae to set time. i mean to say there is a coloumn where it has a list for every minutes right from 0:00:00 to 23:59:59 it many cells in a day, i need to add the hour number for every cell in the adjoining coloumn, is there anyway that we can add formulae and then by using that it automatically gets reflected with the hours. please help me out of this.