[ms office - 2010] Excel, How do you subtract dates?

[S_Hannah]

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?

[mac_shinobi]

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 ?

Edited March 5, 2012 by mac_shinobi