Subtracting time values

  • Thread starter Thread starter fishphone
  • Start date Start date
F

fishphone

I am trying to calculate the difference between two cells which ar
formatted with Custom [h]:mm option. It has so far worked fine unti
now, the higher of the two values is over 10000:00. I now get an erro
stating that the higher value is not greater than the lower value.
think it is because time values are represented by a date time syste
which perhaps cannot work above values of 10000:00
 
Works for me, 1234:00 minus 12:00 gave 1222:00.

Are you the same guy who couldn't add times exceeding 1000 hours recently?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
My original message stated that I couldn't subtract from abov
10,000:00. It works fine for any time below this
 
Back
Top