CODEWITHSUNDEEP
google-sheetsformattingtimestamp
Jaron W.
Jaron W.

Reputation: 27

Time format in Google sheets

I have a 2 columns. One with a planned time of departure and another with actual time of departure. Up until a few days ago, if there was a delay, the difference would read as a negative number. For example, if the planned time was 8:00AM and the actual time was 8:21AM, the 3rd column showed a delay as "-00:21:00"), but now the duration of the delay is displayed as 24:00:00 minus the number of minutes of the delay, as shown in this snippet:

enter image description here

Fortunately, any/all formulas still read and process the values, so this is really just a cosmetic issue for anyone who wants to glance at the raw data.

Upvotes: 0

Views: 47

Answers (1)

player0
player0

Reputation: 1

sounds like the formatting got reset. select your Delayed column and change the format to Duration

Upvotes: 2

Related Questions