Calculating time

  • Thread starter Thread starter Sandi
  • Start date Start date
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if night shift by start & end time 2
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm 1
Difference of time 3
Weird Finding 2
counting cells between two times 5
Auto calculating time 1
Tiem Calculation 8
Calculation Total Time With Dates/Times That Overlaps 4

Back
Top