In article ,
Steve wrote:

Is there another simplier way, or a way to fix this problem. Basically I
need to convert #'s such as 7.5 to 0730.

XL stores times as fractional days, 1 = 24 hours. So one way:

Put 24 in an empty cell. Copy the cell. Select your times. Choose
Edit/Paste Special, selecting the Values and Divide radio buttons. Click
OK.

WIth the cells still selected, choose Format/Cells/Number/Custom and
enter [hh]mm in the input box. Click Ok.