Time is time to Excel. It's formatting that changes what it looks like. But
formatting doesn't change the underlying value.

To subtract one time from another, it's simply:
=a2-a1

It doesn't matter how you enter the time -- the formula remains the same.
You can enter 11:00 or 11:00 am, 13:45 or 1:45 pm, whatever you prefer.

Regards,
Fred

"Sandi" wrote in message
...
In order to calculate time does it need to be milatary time or is there a
formula to calculate time as : 11:00 In
1:45 out
--
Sandi