I am working on a spreadsheet, and I have a cell where I have calculated a total number of hours.

the output of the calculation is 43.81 (hours). If I try and format this to hours (hh:mm:ss) it displays 19:33:20

If I change the formula to display hours - add "/24" at the end of the formula, it displays 1.826 (days), which then reverts to 19:48:53 when formatted as hh:mm:ss.

If I copy the formula cell, and Paste/Values, they still format as 19:33:20/19:48:53 rather than reverting to 43:48