If you need to convert time data to minutes in Excel, you can do as follows: 1. Select the range of time data that you will convert to minutes. 2. Click the Kutools > Content > Convert Time > Time to Minutes. Now a dialog box pops up to show the quantity of converted time data, just close it.How do you calculate hours in Excel?
Another simple technique to calculate the duration between two times in Excel is using the TEXT function: Calculate hours between two times: =TEXT(B2-A2, "h") Return hours and minutes between 2 times: =TEXT(B2-A2, "h:mm") Return hours, minutes and seconds between 2 times: =TEXT(B2-A2, "h:mm:ss")