But it is recognizing 2:00 as just 2 hours. When you enter 2:00 in a cell, and
use it in a formula, it will be treated as 2 hours, regardless of how it's
formatted.

What problems have you have with Excel treating 2:00 as something other than 2
hours?

--
Regards,
Fred


"Display Name" wrote in message
...
I do realize that it is only in the formula bar that 2:00:00 AM is shown, and
when "just viewing the cell" it will display 2:00. However, my question is if
it is possible to have Excel not just display the 2 hours as 2 hours, but how
to have Excel actually recognize a time to simply be time. (and it is in the
formula bar from where we know what Excel is actually doing)

I apologize if I did not explain my question like this to begin with.

"Fred Smith" wrote:

From my experience, Excel does this only in the formula bar. It will abide by
your data entry in the actual cell, unless you've formatted it to something
different. So, either pre-format B1 as General or post-format it as h:mm, and
ignore (or turn off) the formula bar.

--
Regards,
Fred


"Display Name" wrote in message
...
I want to subtract 2 hours from 7:00:00 AM (cell A1), and have the result
(5:00:00 AM) show up in Cell C1. So in cell A1 I wrote "7:00:00 AM" (in the
Custom Number format of h:mm:ss AM/PM); then in cell C1 I wrote "=A1-B1"
(in
the same Custom format as before).
Now, I want cell B1 to equal 2:00 (2 hours). But when I write "2:00" in B1,
Excel changes it to "2:00:00 AM". However, I want the cell to represent
hours--not AM or PM, but just plain old hours.
(For example: Someone will tell you to "see me in 2 hours." But they
wouldn't tell you to "see me in 2 hours AM"?!! Similarly, one says to
"subtract 2 hours from 7:00 AM". But it is incorrect to say "subtract 2
hours
AM from 7:00 AM")

Now, I understand that even with Excel changing it to 2 hours AM (2:00:00
AM), I will still get the desired result of 5:00 AM. However, WHAT I WANT
TO
KNOW IS IF THERE IS ANY WAY TO HAVE EXCEL RECOGNIZE A TIME TO SIMPLY BE
TIME.
NOT AM OR PM BUT JUST A TIME PERIOD OF 2 HOURS?