If anyone can help it would be much appreciated.
I have created a toil spreadsheet with two columns. column A and B with rows consisting of hours (time) with both columns having a total at the bottom (let’s say in row A21 and B21) In C21 I am trying to subtract B21 (hours used) from A21 (hours accrued) but if the used is greater than the accrued then C21 becomes a negative and all I get are hash tags !!

How can I get C21 to read as hours now owed to the company and to put a negative sum ( eg, minus 3 hours )

Also .... I cannot go over 24 hours accrued or used as it sees it as a clock not actually chunks of time, so it goes back to 00:00. I need to be able to add up someone’s toil and they might have accrued 27 hours ?? ... Please advise

Thank you

Jacks