Excel should be able to format 12-hour times without am/pm
"Leith Ross" wrote:
This is a good case for why macro code exists. Here a simple UDF would
solve the problem.
UDF = User-defined-function?
In order for a function result to display in a 12-hour time format, it would
have to return a string, whereas what I'm asking for is a way to format a
time, which can be added to to produce the next time.
One that many members of the various news and
support groups could easily code.
As could I if that would solve the problem. In fact I could do it (perhaps
less efficiently) with built-in functions, but with the same problem of it
returning text, not a time.
It's difficult to imagine Microsoft
making such a consession to please such a small group who either isn't
aware of or is choosing to not use the resources available to them.
Whilst *making* such timetables may not be that large a group, I would have
thought that the ability to format times in this way would me no smaller a
group than many others that are catered for. There are many features in
Office that have me wondering "who on Earth would use that?", but presumably
there is either a bigger demand than I am aware of, or it was easy enough to
code for anyway for completeness.
Beyond that, as I said, it is not a case of not being aware of what's
available or choosing not to use them.
And clearly Microsoft is not going to go to a lot of effort for a few
people, but it would be nice to be able to post a suggestion without having
it immediately dismissed on the assumption that this is the case here.
|