revolving time change formula

Hello,

I have a worksheet that needs revolving times based on the time now, if the time in the cell before the time now it moves up keeping in order, if it is after the time now it moves to the bottom of the list and starts again and this is based on a 24 hour period.

I don't know if this would work as a ranking formula or vba, either solution would be ok, but this on has me stumped.

thansk for your help in advance
reg

Not entirely sure I follow but perhaps:

B7: =MOD(FLOOR($B$3,"01:00")+TIME($A7,0,0),1)
copy down

The use of MOD ensures that as the time cross midnight only the Time value is used (the increment of day is ignored)