Converting numbers to Time

I seem to be in a fix as I am trying to do some calculations in excel. Now doing simple adding and subtracting would not be a problem;however, the format of the data I have in the excel file is the data type numbers and it is in HHMM. Now I wish to convert that into the excel time data type and have it read as HH:MM so that I may do other calculations with it. Since if I leave it as numbers, if I do an operation such as [assume the following are in a 24 hour clock in the format HHMM, and the excel data type numbers] 1145 + 0115 would result in 1260 and not 1300 as need.

Thus, I was wondering if there is any way to convert the data type from numbers to time.

With
A1:A2 containing your posted pseudo-time: HHMM

This formula sums those values in the same HHMM formatted

Please Login or Register  to view this content.

Does that help?