Forum Discussion
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...
Time is always time, we can't go to the past and shift time back. It's always positive. However, you may show time difference not in terms of time, but in terms of hours or days or minutes difference between two events. Taking into account that 1 day is equal to 1, thus 1 hour is equal to 1/24, you may deduct time of event happened at 07:30 from one happened at 08:00, multiply difference on 24 and the result will be -0.5 if you apply General format to it. That means -1/2 hours difference.
Other words, =(B1-A1)*24 with applying General format to the result.