Hi Philip

The problem lies with carrying out calculations. If one is not using
military time, then how does one know whether 5:00 minus 3:00 is 2 hours
or 14 hours?
I understand your requirement however, and the way I would tackle it
would be simply to have 2 extra columns (hidden if required) which held
my times in military format and which I would use for any calculations.
The other two columns, which are the ones I would display, would be
formatted as just hh:mm
In the am column it would be just =A1 (or the cell containing the
military am time)
In the pm column it would be =A1-TIME(12,0,0)

--
Regards

Roger Govier


"Philip J. Rayment" wrote in
message ...
"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.