Hi Richard,
Video 6 at 2:50 minutes. You are typing in "time in" amounts using 8am and when you move to the next cell it changes to (8:00 AM). Was wondering which cell formatting you are using that gives you that. I'm making a mistake here with my formatting and can't get the "total hours". I keep geting #VALUE!,no matter which time format I use.

Thanks
Pat

---

Reply from Richard Rost:

Just use the TIME format from the quick select menu or pretty much ANY time format from the Format Cells menu. Also make sure you type in a SPACE between "8" and "am" as you type it, otherwise Excel will treat it as text (dumb, I know).