I am using the following:

=TEXT((J30/$B$31)/24, "h:mm")

to convert hours and hundreths to hours and minutes. Excel is dropping the
seconds and not rounding up. (e.g., 9:00:36 should round to 9:01)

Any ideas?