excel template calculating time between hours

This then gives a fractional result (2.08333) since it considers the time in hours, minutes as well as seconds. The formula then multiplies this value by 24 to obtain the number of hours that the serial number corresponds to. The serial number corresponding to this time value is actually 0.086806. The above formula first calculates and gives us the difference between the end time and start time in the form of a time value (2:05:00). Here’s how this can be applied to our data samples to calculate the number of hours between each start and end time.įor the first row, use the formula: =INT((B2-A2)*24) The traditional way of calculating the number of hours simply involves multiplying the time difference obtained with 24 (since a day comprises 24 hours) and then rounding the result to an integer value (in case we get a result in fractions). So, for example, say you have the following start and end times:Ĭalculating Hours between Two Times in Excel by Simple Multiplication Since time is basically just stored as a decimal number in Excel, calculating the time difference just requires finding the difference between the two-time values, as follows: Time difference = End time – Start time Also read: How to Add Hours to Time in Excel? How to Calculate Hours between two Times in Excel In the same way, a minute is represented as 1/60th of an hour, and a second is represented as 1/3600 th of an hour. Similarly, the time value for 06:00:00 is 0.25 because 6 AM is a quarter of a day. This means the time value for 12:00:00 in Excel is 0.5 (since 12 hours is half a day). Therefore, an hour is represented as 1/24 or 0.0416667. This means that time is internally stored as a decimal number, where 24 hours are represented with a value of 1.0.Īn hour is simply one-twenty-fourth of a day. In Excel, time is represented as a fraction of a 24-hour day.

How to Calculate Hours between two Times in Excel.

Excel template calculating time between hours