Forum Discussion
Cell Formatting Issue
This seems ridiculous. Simple employee timesheet. Most cells format OK. Simple sum and other calculations. When trying to format cells for in/out times (e.g.; 9:00 AM), sheet always reverts to date a...
Excel simply doesn't work that way.
See Date And Time Entry for a way to make Excel convert 900 (but not 9) to 9:00 automatically in certain cells. It requires VBA.
OK. Thank you for taking the time to provide assistance. I'm one of those who knows just enough to be dangerous.