Microsoft Excel Question

[catnapper]

Ok, now I am really just confused! I tried to change it to 12.15 and 1.00 and it made the 12.15 to 3:30AM

SO from now on, instead of 12:15 I should write in 12.25 to mean the same thing? Won't that be confusing? Ooo... and now I'd have to type in 13.00 for 1:00, right?

Now I really do feel like a moron! Considering how much trouble I can see me having typing in time on the 24 hour format and using decimals instead of the time, I might be better off sticking to manually entering info - I'll enter in just as many typos trying to convert to 24 hours and decimal

[Lady's Human]

Catnapper, It would probably be easier for me to build what you want than to try to explain it via a forum. No, you're not stupid, it's Microsquash's programmers who make things hard for normal people.

[king2005]

Catnapper, It would probably be easier for me to build what you want than to try to explain it via a forum. No, you're not stupid, it's Microsquash's programmers who make things hard for normal people.

hmmm I always thought it was Microcrap

[pnance]

You don't actually have to convert to military time, excel will do it for you if you have the correct format, just make sure the format is set for time and chose the option 24 hour time (ex: 13:30). When you enter your time the catch is you can't just enter numbers you'll have to enter AM or PM for it to change the time to the correct one. (Ex: enter 1:45 PM excel changes it to 13:45) Make sure your calculation cell (c) is also formatted for time.

[Randi]

Kim, if you're a moron about Excel, so am I!! I just don't get it either.

Many years ago when I went to Spain, my teacher made this conversion sheet for me - at the time, 100 pesetas was 4,65 DKR.

Now, I'd like to use this sheet for other currencies - like US Dollars. I'm just not sure what to type in where.

If 1 DKR = 0,1634 US Dollars what do I type in, in cell A1?

I'll attach two images of the sheet. In the second one, I clicked to get the formula visible.

Can anyone help?