Hi folks,

Trying to create a sheet to tally up fish weights for a small fishing tournament. The weights would be entered in decimals and I would like the sheet to total up everyones weights and output a total weight that reads in "# lb # oz".

I have a test sheet going here where I'm trying to convert cell B34 cell value "1.16" (1lb 16oz) to read "2 lb" in cell B35.

Hope someone can help.

Thanks!