You can enter the time in 24 hr format like this:

h:mm

0:30 = 12:30 AM
7:30 = 7:30 AM
12:00 = 12:00 PM
18:00 = 6:00 PM
23:45 = 11:45 PM

To caculate the hours worked:

A1 = start time
B1 = end time

=MOD(B1-A1,1)

Format as h:mm

--
Biff
Microsoft Excel MVP


"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