Replies

The formula you gave me keeps giving me an error message. I was unable to clear format of results, because I couldn’t get results because of the error message. The blue cell I was wanting to display currency ( H column)

(Edited by S Peters on 14-Jan-04 10:01. more info)

I’m not very familiar with Excel, but am trying to learn. I am trying to find a formula where if say G12 is less than 3, it should show 19.95. g12 is a sum of another 2 cells. I am attaching an example of what I am doing. The message I got from Legare Coleman keeps giving me an error, so maybe he needed to see what I was doing. I have tried using Excels formulas, but was unable to figure out just what they needed.

(Edited by S Peters on 14-Jan-04 10:01. more info)

I’m not very familiar with Excel, but am trying to learn. I am trying to find a formula where if say G12 is less than 3, it should show 19.95. g12 is a sum of another 2 cells. I am attaching an example of what I am doing. The message I got from Legare Coleman keeps giving me an error, so maybe he needed to see what I was doing. I have tried using Excels formulas, but was unable to figure out just what they needed.

Thanks so much for all the help people. I was having some troubles with all these suggestions until I found the right formatting for the particular cells. Was also having trouble converting the accumulated times into earnings until I tried using the *24 thing with the right formatting in the cells. Again Thank You all. You are fantastic.

I have been playing with this formula using the .50 hours instead of the 30 minutes, and works great. The only thing is if I use 09:15 or 09:45, the answer does not come out right. Maybe I will have to stick to half hours. Thanks for the help.

I have been playing with this formula using the .50 hours instead of the 30 minutes, and works great. The only thing is if I use 09:15 or 09:45, the answer does not come out right. Maybe I will have to stick to half hours. Thanks for the help.

This helps clear things up a little. But, what do I do with these 8 fields. I am only using a workweek schedule, so do I paste the single instance in the first cell and the next 4 in the next cells? Told you I don’t know a thing about this, but slowly I’m learning.

I’m sorry. I don’t know anything about this stuff. I don’t see any instructions on how to set something like this up. I don’t have a clue.

That Microsoft article did the trick. You guys are awsome. Thanks a lot.

They do change color until you click somewhere else, then they are the original color. My problem is that they are dead. they don’t get me to the page I’m looking for.

Thank you very much. That was the problem. I never would have thought to go that route.OOps. Worked once. Now it’s back the same way, but the settings stayed.

Thank you so much. So simple, yet I never thought to look there.

I was trying to do it in the left hand bar under the customize, and found the utilities talked about, but there is no way I can find to add to what is there, which is msn. I would appreciate anything that would help.

Thanks, but I have been there. There are no options there, and it will not let me add any.

I am wondering if I can get them to change color when they have been visited so I know if I have used them.