Clock time to be by default PM?
- Thread starter Harry0
- Start date
Chihiro
Excel Ninja
Note that Excel stores time value as decimal (1 hour = 1/24). And just displays AM/PM portion using formatting. If you force Excel to display 9/24 as 9:00 PM...
This will cause issues.
It will throw off calculation. Even if you adjust calculation, it will confuse anyone looking at the workbook later. Among other things.
So, my recommendation, is not to do this. Just use 24 hour clock to track things.
This will cause issues.
It will throw off calculation. Even if you adjust calculation, it will confuse anyone looking at the workbook later. Among other things.
So, my recommendation, is not to do this. Just use 24 hour clock to track things.
GraH - Guido
Well-Known Member
Hi, you can't change AM/PM since it is an international standard. AM is all from midnight until noon, PM is from noon until midnight.
Anyways a "format" is just how the data is "shown" in the cell, not how it is entered. I guess you want to enter something like 1:15, and that excel should see 13:15. The decimal values are (rounded) 0.05 and 0.55. I don't see a way a "format" can turn 0.05 into 0.55 and vice versa.
How would you enter 1:15?
Anyways a "format" is just how the data is "shown" in the cell, not how it is entered. I guess you want to enter something like 1:15, and that excel should see 13:15. The decimal values are (rounded) 0.05 and 0.55. I don't see a way a "format" can turn 0.05 into 0.55 and vice versa.
How would you enter 1:15?
Harry0
Member
I prefer it to also put a 9 and it says 9:00 AM since like normal people write and talk. I expect to say 5 and it knows its obviously not 2 am since normal people say 9 to 5, and not 9:00 am to 5:00 pm, and not military time to say 0900 hours to 1300 hours.
Many times it shows people that makes programs do not have real jobs and are in their own bubble like many heads in MS.
Thanks but 24 hour wont do and it confusing to many despite it is not for you. So many limitations with excel it seems maybe it has to be scraped and done again from the start. LOL Why not they keep changing OS interface every so often to confuse people. LOL I guess I would need to use tricks to accomplish it. with extra columns of code.
Many times it shows people that makes programs do not have real jobs and are in their own bubble like many heads in MS.
Thanks but 24 hour wont do and it confusing to many despite it is not for you. So many limitations with excel it seems maybe it has to be scraped and done again from the start. LOL Why not they keep changing OS interface every so often to confuse people. LOL I guess I would need to use tricks to accomplish it. with extra columns of code.
GraH - Guido
Well-Known Member
What would 5 to 9 be then in your logic?
To whom would 24h be confusing? Sorry, it is just logical, nothing confusing about it. Excel is a spreadsheet program, and is built on maths rules. Thus all about logic.
Normal people also say: "It was 3 in the middle of the night." or, "At 1 in the afternoon". Sounds a lot like AM/PM to me.
To whom would 24h be confusing? Sorry, it is just logical, nothing confusing about it. Excel is a spreadsheet program, and is built on maths rules. Thus all about logic.
Normal people also say: "It was 3 in the middle of the night." or, "At 1 in the afternoon". Sounds a lot like AM/PM to me.
Harry0
Member
"What would 5 to 9 be then in your logic? " That is not normal work time for the majority.So that is a condition one has to take into account which excel does not rely on real world problems sometimes. It is like not having short cuts on your desktop or everything is in binary since whats so hard about binary math when its only 1 and 0 in how you present it.
I was thinking of using overlapping cells to solve it but again excel can't handle even that as well since it does not do numbers but letters.
to say 3 in the middle of the night one has to state since its not common for most to be up that time. To say 1 in the afternoon again is rare but some are up at 1am.
Also a teacher told a student to come to class at 11:00 and the student says in the morning teacher? obviously no classes are open at 11pm for public schools.
I was thinking of using overlapping cells to solve it but again excel can't handle even that as well since it does not do numbers but letters.
to say 3 in the middle of the night one has to state since its not common for most to be up that time. To say 1 in the afternoon again is rare but some are up at 1am.
Also a teacher told a student to come to class at 11:00 and the student says in the morning teacher? obviously no classes are open at 11pm for public schools.
GraH - Guido
Well-Known Member
At uni, I followed classes at 9 PM, and I've worked in "normal" shift regimes from 7-12 and 12-19. Just saying.
So according to you, Excel should "know" what the context is of the numbers your are encoding in cells. I find that a strange expectation. Then again, I don't have shortcuts on my desktop. I must be weird by definition.
So according to you, Excel should "know" what the context is of the numbers your are encoding in cells. I find that a strange expectation. Then again, I don't have shortcuts on my desktop. I must be weird by definition.
Harry0
Member
its not about excel knowing what the person wants, its about excel being able to input shortcuts in what the person wants to select options than no options at all. The point of excel was to make things easier and faster. 
But o well. Something is better than something. Thanks anyway.
But o well. Something is better than something. Thanks anyway.