Excel Query

  David4637 20:08 PM 30 Aug 11
Locked

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

01:00:00=11:00:00-10:00:00

C1=B1-A1

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.

http://www.mrexcel.com/forum/showthread.php?t=341459

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

Advertisement

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

Sony Xperia Z5 vs Xperia Z5 Premium vs Xperia Z5 Compact: What's the difference between Sony's new ?…

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

This 3D food printer prints chocolate, cookie dough or pizza

iPhone 6S preview: What to expect from Apple's next iPhone