+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Excel, How do you subtract dates? in Technical; Hi, In my excel spreadsheet, I have a column named start and one named end. I enter data in the ...
  1. #1
    S_Hannah's Avatar
    Join Date
    Oct 2009
    Location
    Manchester
    Posts
    65
    Thank Post
    16
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Excel, How do you subtract dates?

    Hi,
    In my excel spreadsheet, I have a column named start and one named end. I enter data in the fields as follows:

    Start Finish
    01/02/2012 12:23 02/02/2012 :14:34

    I want to know if it is possible to subtract the finish from start to show how many hours its taken to completed.

    Any IDeas?

  2. #2

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,230
    Thank Post
    2,773
    Thanked 937 Times in 877 Posts
    Rep Power
    343
    DateDiff Function

    DATEDIF Worksheet Function

    Although this can only give difference in days, see here --> Calculate Hours Between Two Dates and Times in Excel | Excel Semi-Pro

    Calculating Hours Between 2 Dates and Times

    If we recall that the unit of time is “the Day,” this value represents 1-1/3 days of time. Since there are 24 hours in a day, converting to hours is a simple multiplication 24 * 1.3333 = or 32 hours. (24 * 4/3 to be more precise)
    Finding the number of hours between two date/times is simple, just subtract the start date/time from the end date/time and multiply the result by 24 hours.
    If you want to enter the dates and times separately (which is loads easier than typing in a date/time in one cell) then add the date/times together.
    Hours = ((End_Date+End_Time)-(Start_Date+Start_Time))*24
    Here’s a look at a typical worksheet designed to calculate the hours between two dates.
    Other option might be a VBA Sub or Function if you need it calculated more precisely ?
    Last edited by mac_shinobi; 5th March 2012 at 06:52 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. How do you like to keep cool during these hot spells?
    By ninjabeaver in forum General Chat
    Replies: 19
    Last Post: 28th July 2013, 10:03 PM
  2. How do you do remote authenticated access to the intranet
    By daverage in forum Wireless Networks
    Replies: 9
    Last Post: 2nd February 2006, 01:34 PM
  3. How do you OU?
    By ajbritton in forum Windows
    Replies: 7
    Last Post: 2nd November 2005, 01:45 PM
  4. Printer Consumables... How do you do it!!!!
    By ChrisH in forum General Chat
    Replies: 24
    Last Post: 5th July 2005, 12:31 PM
  5. How do you do.....it?
    By Dos_Box in forum General EduGeek News/Announcements
    Replies: 4
    Last Post: 20th June 2005, 10:32 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •