In my excel spreadsheet, I have a column named start and one named end. I enter data in the fields as follows:
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.
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
Other option might be a VBA Sub or Function if you need it calculated more precisely ?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.
Last edited by mac_shinobi; 5th March 2012 at 06:52 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)