Calculating time

S

Sandi

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
 
L

Luke M

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.
 
F

Fred Smith

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
 
Top