While working with time and dates in excel, you frequently get the need to calculate hours, minutes and seconds between two timestamps.
Well in excel 2016 calculating the time difference is quite easy. You just need to subtract the start time from the end time.
You are assigned five tasks. You enter the start time of a task whenever you start it.
In the next column you have NOW() function of Excel is running that give. NOW() in excel is used to calculate the current time.
In the next column, you want to calculate the minutes passed since you started that task, as shown in the above image.
The Generic Formula to calculate the minutes between two times is:
|(END TIME – START TIME)*1440|
We subtract time/dates in excel to get the number of days. Since a day has 1440 (24*60) minutes, we multiply the result by 1440 to get the exact number of minutes.
For this example, we write the formula below in cell D2 and copy it in the cells below:
So, we cleared our doubts about how to calculate time in excel 2016. This can be done in all versions of Excel including excel 2013, Excel 2010, Excel 2007, and even older versions
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.