Military Time Excel

Good Morning,

What I'm trying to do is create a schedule in excel which adds two cells containing military time without a date ex: [2200] + [0600] into a total numbers of hours. ex: [2200] + [0600] = [8.00]

I've done this before I thought I just used a simple SUM function, I can't seem to get this for the life of me. I want to just be able to enter a time and excel understand what I'm talking about. I used to simply type the times into the cell and it would appear as entered. Typing "2200" into a cell would appear as [2200], which is what I want.

Currently, I've changed the format to hhmm and when I type "2200" into a cell it appears as [0000] when I click the cell to see the value, the value has defaulted to "1/8/1906 12:00:00 AM".

If anyone knows how to do this, I'd greatly appreciate the advice. I know it can't be too difficult because I did this on a whim about 4 months ago and decided not to use it.

I worked for a company who used this as well, its where I got the idea, in February we merged into a new company which uses an absolutely insane schedule format that is difficult to read unless you're working with about 10 employees.

 

See if this helps
http://answers.microsoft.com/en-us/...t-having/4b20793b-e944-e011-90b6-1cc1de79d2e2

You really will have it easier if you put in the colon
https://support.office.com/en-ca/ar...-of-time-9a6558a1-a86b-41d4-b244-1000fc7d31e9