0

I'm having trouble getting negative hour as a result. For instance:

G           H
08:30       06:00

I would like to get a column with the difference between H and G. So I would be filled with -02:30.

When I do a simple calculation, like G2-H2, I get 22:00 as a result.

Any ideas on how to fix this?

I saw this post How to handle Negative Time Delta in Google Spreadsheets, but none of them have the solution I'm looking for.

2
  • Is your question about Excel or Google Sheets? What are the values shown for each cell in the formula bar?
    – Rubén
    Jan 14 at 20:29
  • Please remember that you can also contribute to this community that helps you. As per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. Jan 15 at 18:05
0

You mention

I would like to get a column with the difference between H and G. So I would be filled with -02:30.

The formula =H2-G2 will work fine in Google Sheets once you format as Duration by going to
Format - Number - Duration

enter image description here

1
  • Thank you for taking the time to accept. Jan 16 at 0:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.