We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Time Between Dates

Options
Cotta
Cotta Posts: 3,667 Forumite
Hi All,

I have two columns on a spreadsheet A and B. A states the time when an order was requested e.g. 04/04/2013 and B states when it was processed including the time e.g. 01/01/2014 11:05. How can I calculate the difference in days between the two dates?

Thanks

Comments

  • droopsnoot
    droopsnoot Posts: 1,868 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    In my Excel (2010), I just entered a formula to subtract one from the other. I'm guessing it assumes midnight for dates where no time is specified, as it gave 44.45-odd for the answer, so you just need to int() that:

    =int(b1-a1)

    Probably.
  • AndyPix
    AndyPix Posts: 4,847 Forumite
    Fifth Anniversary 1,000 Posts Name Dropper Photogenic
    Just do -B-A

    That will give you the number of days as a floating point eg 3.458333 etc

    eg 3.4 days

    you can then just round down or up as you require
  • AndyPix
    AndyPix Posts: 4,847 Forumite
    Fifth Anniversary 1,000 Posts Name Dropper Photogenic
    yeah - what he said ^^
  • Cotta
    Cotta Posts: 3,667 Forumite
    Great stuff guys, I didn't think it would be that easy.
  • GunJack
    GunJack Posts: 11,829 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    even easier, just have both input and the output cells formatted as dates, and subtract one from the other
    ......Gettin' There, Wherever There is......

    I have a dodgy "i" key, so ignore spelling errors due to "i" issues, ...I blame Apple :D
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.9K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.9K Work, Benefits & Business
  • 598.7K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.