Excel Query

  David4637 20:08 30 Aug 2011

I want to find the answer to subtracting 2 times in Hrs Mins Secs. EG Start time 10.00.00 End Time 11.00.00. Telling me the answer is 1 Hr 0 mins 0 secs. Thanks David

  wee eddie 21:42 30 Aug 2011



Or, have I totally misunderstood your question

  AroundAgain 23:21 30 Aug 2011

Hi This post entrigues me so I've had a look in Excel Help and it came up with "Calculate the difference between two times". I'm using only version 2003, but this might start you on the tract.

Also, I tried Google'ing "Excel calculate the difference between two times" and, as well as the Help instructions, I wondered if this web page might help, although for version 2003. I don't know what version you are using.


I would be interested to hear how you managed. I have to admit to not managing to get the suggested formulae to work for me! Maybe I'm typing something in wrongly!

Hope this helps Cheers

  VoG II 07:11 31 Aug 2011

You need to enter times like 10:00:00 otherwise Excel will not recognise them as times.

  AroundAgain 09:19 31 Aug 2011

Thanks, VoG I've now worked it out, thanks to you. Hope David has got the solution to his problem, too! Cheers

  David4637 15:52 31 Aug 2011

Thanks all for your replies, I have worked out what to do and it works in Excel 2000, the version I have. All the best to you David

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?