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. ## 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. 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 ?

SHARE: