I have tried using a simple subtraction equation to determine the difference in hours using military time, however when you get to half hour increments, for example, 1700 - 1230, You see the minutes as 70, which is the correct subtraction. I need to know how to convert the 100 units to 60 showing 5 hours and 30 minutes, not 4 hours and 70 minutes. I thought if inserting an if statement to add 160 units, but can't remember the condition "ends with" 70. Thank you!.

It is probably happening because you do not have the cells formatted as TIME. In cell A1 enter 17:00 << NOTE the colon - it is REQUIRED

In cell B1 enter 12:30 << NOTE the colon - it is REQUIREDIn cell C1 enter the formula =A1-B1

you should now have an answer of 4:30MIKE

Don't start a new thread for the same question. I have deleted your other post as you have a perfectly good answer here If you need clarification, post in this thread.

Stuart

Thank you for the response. I did try format the cells to time, but when I put in the data, it comes back as 00:00 PM. I'm not sure what I am doing wrong, but I did find a formula that worked:

=(60 * (DOLLARDE(B3/100, 60) - DOLLARDE(B2/100, 60) + 24 * (B3+0 < B3+0) ))Again, thank you Mike!

Are you going past Midnight with your calculations?

Did you enter the time with or without the AM/PM?Here is a great source for Date & Time info:

http://www.cpearson.com/excel/datet...

MIKE

Ask Your Question

Weekly Poll

Do you think people should be allowed to list their rented apartments on Airbnb?

Discuss in The Lounge

Poll History