G
Guest
I have two columns say A and B. In these two columns I enter the time in and
time out. Everything works fine till I reach 12:00 PM. Then for some reason
excel forgets whether it is Am or Pm. Is there some way to get it to not
switch back to Am?
Second question: I also subtract the two columns to get a total time spent
for each activity. If I have the start time entered in column A but no end
time in column B I recieve an error message which throws off my running
totals. Can I fix it so that it will not run the total until I have entered
a time in column B?
Thanks in advance,
Steve
time out. Everything works fine till I reach 12:00 PM. Then for some reason
excel forgets whether it is Am or Pm. Is there some way to get it to not
switch back to Am?
Second question: I also subtract the two columns to get a total time spent
for each activity. If I have the start time entered in column A but no end
time in column B I recieve an error message which throws off my running
totals. Can I fix it so that it will not run the total until I have entered
a time in column B?
Thanks in advance,
Steve