Couldn't the formula be shortened to =TEXT(A2,"hh")&"00-"&TEXT(A2+1/24,"hh")&"00"?