dating system

Dennis Faas's picture

Displaying Negative Times in MS Excel

My son-in-law came to me recently with a problem he was experiencing in MS Excel. He is a director in his company and is charged with keeping track of his employees' time. He wanted to be able to display a negative time in his MS Excel spreadsheet. ... I have to tell you -- I had a time figuring out this one. After doing some research and digging around a bit, I found that the easiest solution to this problem is to simply change the date system used by the workbook. I agree that it sounds a bit strange, but it works. The default date system for Windows versions of MS Excel is 1900 and if you are ... (view more)

Subscribe to RSS - dating system