Subtracting time using [H]:mm function



Hi, I'm using the custom cell format [H]:mm to add times of tasks
entered by remote workers. I want to show a variance from the budgetted
hours which means the answer will sometimes be negative. The cell then
only shows *****. I can't find any way of calculating and displaying a
negative time answer such as -13:12, meaning 13 hours 12 minutes over
budget. Can you help? Thx

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question