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

You can either input the values using military time standard, or use AM/PM.
How it "looks" is determined by how you format the cell. If you inputted the
values you correctly, you can do a simple:
=A2-A1
to calculate the time difference.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sandi" wrote:

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

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