How can I calculate the difference between two time fields, being the second greatest than the first one?

Question

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.

Is your question about Excel or Google Sheets? What are the values shown for each cell in the formula bar? — Rubén - Volunteer Moderator -, Commented Jan 14, 2021 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. — marikamitsos, Commented Jan 15, 2021 at 18:05

marikamitsos · Accepted Answer · 2021-01-14 21:37:38Z

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

answered Jan 14, 2021 at 21:37

marikamitsos

13.1k4 gold badges34 silver badges59 bronze badges

Thank you for taking the time to accept.
– marikamitsos
Commented Jan 16, 2021 at 0:04

Add a comment |

1 Answer 1