Forum Discussion

Copper Contributor

Sep 29, 2020

How to display negative amount of time

Hi everyone, I’m making a worktime sheet for my husband. I’m not having any trouble deducting his start and stop times, but I made a column for the amount of hours he’s supposed to work, and a c...

excel

office 365

NikolinoDE

Gold Contributor

Sep 29, 2020

Lynn_vdb

Change the way negative numbers are displayed

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011

https://support.microsoft.com/en-gb/office/change-the-way-negative-numbers-are-displayed-104b47a6-8ae2-471f-8f73-c4b96e7bb146?ui=en-us&rs=en-gb&ad=gb

Create a custom number format

https://support.microsoft.com/en-us/office/create-a-custom-number-format-78f2a361-936b-4c03-8772-09fab54be7f4

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.