=(end_time-start_time)*1440ĭon’t worry you can use a better formula for this. It happens sometimes that you need to track the time difference in minutes instead of hours, and in this case, the best way is to use the below formula. So when you enter this formula, first of all, it returns a decimal number for the hours, and then INT removes the fractional part and gives you completed hours. INT function returns the integer part decimal by rounding it down. This formula is just like the formula which we have used in the second method, the only difference is here we have wrapped it in INT. You can also calculate the completed hours between two times with this simple formula. And when further you multiply it by 24 (the total number of hours in a day) it converts that decimal into the number of hours and minutes. How this Formula WorksĪs I said before, Excel stores date and time in numbers, and when you deduct the end time from the start time it returns a decimal. Once you enter this formula it returns the hours in numbers and minutes (if you have them) in decimals.
0 kommentar(er)
