Excel: Convert Whole numbers to military time for calculations

in cell A1, I have whole number formatted as 00\:00 to insert the colon. In B1 I have military time formatted as h:mm. I need to add cells A1 and B1 to get a total. Appreciate anyone's help in this matter. Ron Abraham

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of October 08, 2014.

For more resources for Microsoft Excel