A time is a time to Excel. It doesn't matter how it's entered or how it's
formatted. It's still the same time. For your first question, format the
cell as:
hh:mm
You can now enter 2:00 PM or 14:00 and the cell will always display military
time.

For your second question, times are just numbers to Excel, so you do regular
arithmetic with them. In your case, it's:
=a2-a1

Format the way you want (like he:mm)

Regards,
Fred.

"Dukey" wrote in message
...
I need a formula so when I type in 2:00 PM it gives me 14:00. Or when I
type in 7:00 PM it gives me 19:00. Also need a formula to add the
military
time. For example: If I come to work at 08:00 AM and leave at 5:00PM
(17:00 PM) it will give me the amount of hours worked.

Thanks Dukey