Excel: Formula to calculate time and day differences

Asked By Chandramoulikankarajan001 10 points N/A Posted on - 08/04/2011

Can anyone help with this Excel formula question?

Created Time	Completed Time
Apr 28, 2011 09:38 PM	May 5, 2011 06:15 AM

I want the formula to find the days & time between these dates.

Thank you.

• Status: Open
• Question Views: 1327
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by manojdabhi

Go To Solution

Best Answer

Best Answer

Answered By manojdabhi 0 points N/A #98991

Excel: Formula to calculate time and day differences

Please note that Excel formulas cannot be applied to characters and so you will first need to convert the date completely into numerical form.

If you type"Feb 1, 2011 8:30 AM" and press enter into a cell then it will automatically get changed into "2/1/2011 8:00" format. I will suggest you to change all the dates to this format by just clicking once onto each cell containing dates and press enter.

By default you will get the above format. Once you get the above format you can easily get the total difference between two dates in hh:mm:ss format by using the formula "=A2-A1" (considering that both cell A2 and A1 contains date). 

Once you get the answer, select that cell and change its format to [h]:mm:ss, by using cell formatting and then selecting custom category.

Also note that you can select many more formats for your answer available in the custom section of cell formatting. Thanks!   

Please check the attachment for more idea. It contains a sample.

About manojdabhi

Questions
0

Answers
3

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/08/2011
• Question Category: MS Excel

Answered By Chandramoulikankarajan001 10 points N/A #98992

Excel: Formula to calculate time and day differences

Thanks a lot was a great help to me…

 

About Chandramoulikankarajan001

Questions
4

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/09/2011
• Question Category: MS Excel