Excel quandary: Negative days or time — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Excel quandary: Negative days or time

Get PDF file

by on
in Excel Training,Office Technology

Q. I keep getting endless pound signs (#) in my cells. What am I doing wrong?

A. This usually occurs when Excel thinks you’re trying to calculate something that results in negative days or negative time. It can be more a format problem than a calculation problem. If you are expecting a value representing the difference between two times or dates in a numeric value, all you have to do is clear the formats (Home, Editing, Clear, Clear Formats). If you want the result to be formatted as a time or a date, then you will need to reverse your calculation. In other words, it will need to result in a positive number.

Leave a Comment

 

Previous post:

Next post: