Excel Query

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

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

C1=B1-A1

Or, have I totally misunderstood your question

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

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

  AroundAgain 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 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.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

IKinema aims to banish droopy shoulders and wonky spines in animated CG characters

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message