Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Excel Query

David4637

Likes # 0

Posted August 30, 2011 at 8:08PM

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

Like this post
wee eddie

Likes # 0

Posted August 30, 2011 at 9:42PM

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

C1=B1-A1

Or, have I totally misunderstood your question

Like this post
AroundAgain

Likes # 0

Posted August 30, 2011 at 11:21PM

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

Like this post
VoG II

Likes # 0

Posted August 31, 2011 at 7:11AM

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

Like this post
AroundAgain

Likes # 0

Posted August 31, 2011 at 9:19AM

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

Like this post
David4637

Likes # 0

Posted August 31, 2011 at 3:52PM

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

Like this post

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.