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.

How to get Windows 10 now: how to download and install Windows 10 even if GWX.exe is missing

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

Nokia rolls out spherical camera for virtual reality apps

7 best iPhone web browser apps: Why Safari for iOS is still a better option than Chrome, Dolphin,…