Excel: Adding hours and minute more than 10000 hours

Dear, I have a problem in excel and I need your assistance . Here there is example of the question I have. A1=00:20 means 0 hours and 20 minutes B1=01:30 means 01 hours and 30 minutes C1= 20000:00 means 20000 hours and 0 minutes my question is to calculate D1 which should be equal to C1-B1-(A1/5) Best regards

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

This thread is current as of February 23, 2017.

For more resources for Microsoft Excel