Hey, I'm trying to keep track of my hours at work, but I'm having a lot of trouble with excel changing the data I input. Right now it looks like this:
\1 (would have just entered pic but had trouble)
When I try to enter 7, to mean 7:00 AM, it will change to 12:00 AM. I would just enter 7:00 AM, but in column F I want to take the word 'hours' out and just have numbers ( 00.00) so that I can have it automatically add it all up down in column 8F. If that makes sense... I was hoping that by changing the time from 7:00 AM to just 7, it would stop messing with column F. Right now column F changes to 12:00 AM when I take the word 'hours' out, and when I try to do the =SUM(F2+ etc etc) I receive an error message (obviously because the word 'hours' is in there).
So THAN, I tried to put brackets around the times, like this:
\1
But in column F the info I input STILL changes when I take the word 'hours' out. I would like to say that I have not put any formulas into this program yet.
Does excel have any functions made for keeping track of how many hours are worked? Is there a way to turn off excel's function to change inputed data? Thanks for any help!
Bookmarks