Couldn't the formula be shortened to =TEXT(A2,"hh")&"00-"&TEXT(A2+1/24,"hh")&"00"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks