View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Philip J. Rayment
 
Posts: n/a
Default 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.