Excel Query

  David4637 20:08 PM 30 Aug 11

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 PM 30 Aug 11



Or, have I totally misunderstood your question

  AroundAgain 23:21 PM 30 Aug 11

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 AM 31 Aug 11

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

  AroundAgain 09:19 AM 31 Aug 11

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 PM 31 Aug 11

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.

Sony Vaio Z Canvas release date, price and specs: Another Surface Pro rival but for the US

1995-2015: How technology has changed the world in 20 years

Adobe unveils Sketch-rival Project Comet for UX design

How to fix iOS 9 problem iPhone stuck screen, unresponsive, no swipe, frozen, can't turn off