Display Name

If you formate the cell with 2:00 in it as h:mm it will display as i think
you want.

Mike Rogers

"Display Name" wrote:

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?