I am trying to subtract hours to a time that is close to midnight, but excel is outputting all hash (#) symbols complaining of the operation.
Adding time is easy and possible, as described by this first example:
For example, I have a cell with the value 11:00 PM (the column is formatted to this time format). I need to add 2 hours to it and get 01:00 AM. Assuming that cell A1 has the
11:00 PM value, I use
=A1+time(2,0,0) and get 01:00 AM, which is what I expect.
However, when I try the reverse of this operation (minusing), excel outputs all hash symbols.
For example, I have a cell with the value 01:00 AM. I need to minus 2 hours to it and get 11:00 PM. I try
=A1-time(2,0,0), but all I get are hash symbols from excel.
How can I subtract a number of hours (or minutes) from a time that is very close to midnight?