Calculating time
 

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

Calculating time
 

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

Calculating time
 

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