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

PReagan

Bronze Contributor

Sep 29, 2020

Hello Lynn_vdb,

Assuming the actual end time is in cell A1, the anticipated end time is in cell B1, and the difference is in cell C1, then that could be:

For hours:

(A1-B1)*24

For minutes:

(A1-B1)*1440

Also, be sure that cell C1 is formatted as either General or Number.