Search results for query: *

I have been working on this spreadsheet for awhile now and I am always looking to improve it. I have come to the conclusion that I will not be able to have excel recognize when it is am or pm so I came up with another idea, sure I am not the only one to have thought of this. I want to use a...

Thanks for the help I was able to do it with no problems.

Sorry for the double post but I forgot to mention that instead of the error showing up I want it to say Open or something like that.

How do I hide errors such as #VALUE! in excel 2002 using VBA?

Thanks for the help. It seems to me that in order to use one of those commands I would need to use two cells just to get PM. If possible I just want someone to have to type in 1:00 and get 1:00pm in a single cell. We are open from 9:30am - 9:00pm most days. As you can tell I am not the most...

I have an excel document set up to figure out how long someone has been on a computer at my job but it is not as user friendly as I would like it to be. I am trying to figure out how to get it so that when someone types in a time like 6:00 it doesn't automatically assume that it is 6:00 am. I...

Thanks for the help. This actually helped me with two things I was trying to figure out. I thought I could use the conditional formatting just wasn't sure what to put in to get it to do what I wanted. Thanks again.

I work in a computer room in a library and made something in excel to determine how long someone has been on a computer for. What I would like to do is have it so that after someone has been on a computer for an hour for the cell to turn red. I have no idea how to do this as I am basically just...