|
calculate positive and negative times in excel 2003 (new) [duplicate]
i have a goal of 2h47m00s minutes per month. if i attend let say 1h20m00s and when my excel cell format is [Red]-[m]:ss;[Blue][m]:ss it gives me in red color 87 minutes time difference before i reach my goal. When it's negative it gives me the right answer. But if i reach 3h00 normally it should give me 13 minutes colored blue, but it doesn't. It gives me ################# as an answer. Can someone help me get the right formula. Thanx And its not a problem of widening the cell.
| 