You don't actually have to convert to military time, excel will do it for you if you have the correct format, just make sure the format is set for time and chose the option 24 hour time (ex: 13:30). When you enter your time the catch is you can't just enter numbers you'll have to enter AM or PM for it to change the time to the correct one. (Ex: enter 1:45 PM excel changes it to 13:45) Make sure your calculation cell (c) is also formatted for time.
Reply With Quote
Bookmarks