+ 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
    Thank Post
    Thanked 1 Time in 1 Post
    Rep Power

    Excel, How do you subtract dates?

    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
    Thank Post
    Thanked 1,030 Times in 955 Posts
    Rep Power
    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.

+ 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