You have to realise that if you store the hours as numeric, then 100.5
and 200.25 represent 100 hours 30 mins and 200 hours 15 mins
respectively. However, if you really want to show this as hours and
minutes, the following formula in C2 will do this:

=TEXT(INT(B2),"0")&" hrs "&TEXT((B2-INT(B2))*60,"0")&" mins"

Copy this down column C for as many values as you have in A and B. You
can then hide column B if this causes confusion.

Hope this helps.

Pete