View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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