Excel 2000 Time Calculation
How to write an excel formula to calculate a negative hh:mm result e.g.,
Cell A1 35:00 (required to work) Cell B1 20:00 (actually worked) Cell C1 to return a negative value of 15:00.
Software
How to write an excel formula to calculate a negative hh:mm result e.g.,
Cell A1 35:00 (required to work) Cell B1 20:00 (actually worked) Cell C1 to return a negative value of 15:00.
by dklippert
It's a little compicated, because Excel cannot handle negative dates or times.
Here is the location that will give you some work arounds:
(THere are no spaces in the URLs)
www.cpearson.com/excel/datearith.htm
Also see:
by vivtimmis
by vivtimmis
This discussion is closed to new replies.
Sort by Trending