How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 32232
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I am trying to determine the difference between two dates -

Customer Question

I am trying to determine the difference between two dates - as you'll see in the photo I attached, the timestamp is formatted as such: January 03 2016 01:32 AM - What I want to do is determine the difference in h:mm:ss from the date in Creation Date (column D) and Closed on (columnF). I've tried a Google search and tried (F1-D1) however because the months are in text it's not working. Please help!I'm also looking for a simple solution - not complex.
http://f01.justanswer.com.s3.amazonaws.com/s6haplig/Time+difference.png
Submitted: 12 months ago.
Category: Microsoft Office
Expert:  Richard replied 12 months ago.

Hi there and welcome

Can you attach your file to this question so I can see which format its being stored as

Thank you

Customer: replied 12 months ago.
Hi, This can be closed. I found a solution. Thank you.
Expert:  Richard replied 12 months ago.

ok was suprosed you never responded to me but thanks, ***** ***** can please do the service rating via one of the stars at the top then submit, this will close off the case.