- NEW!
by Cyanotic Wasp on August 4th, 2009
Assuming that the values are stored as time only and do not include a date component, then this formula should work for you:
Times are stored as
Col A = Start
Col B = End
=IF( B2 < A2, B2 - A2 + 24, B2 - A2)
I have excel 2003. I get error: The formula in this cell refers to a range that has additional numbers adjacent to it. What does it mean?.
by stretch on August 21st, 2011
| 1 person likes this
Dynamic chart issue
by Lucian_M on September 18th, 2011
| 1 person likes this
Could someone give me a good definition of VLOOKUP in Excel?
by slimNanny on August 13th, 2011
| 1 person likes this
When I sort a list in Excel it sorts A to Z then A to Z again, not the same items, just half of it on top and half on bottom. Why?
by AndaleTheGreat on August 13th, 2011
| 1 person likes this
What are examples of Spreadsheet application software?
by tinmanEvil on August 13th, 2011
| 1 person likes this
You're reading I have excel 03. I have two columns in military time. I want to take the third column and get the difference. =B2-A2 works fine if B2 is larger than B1. but not the other way around, because of the military time. help?
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!
Comments
thanks for your help. It works. Can I then convert that result to decimal format? in the same column? or do I have to carry it over to a new column?
by Anonymous on August 5th, 2009
The result can be formatted within its same column. Changing format of a number doesn't affect calculation at all.
by Cyanotic Wasp on August 5th, 2009