Hours, minutes, and seconds between two times with the cell formatted as 'h:mm:ss' by using the TEXT function (4:55:00). Hours and minutes between two times with the cell formatted as 'h:mm' by using the TEXT function (4:55). Hours between two times with the cell formatted as 'h' by using the TEXT function (4). You must manually apply the custom format 'h:mm:ss' to the cell. Hours, minutes, and seconds between two times (4:55:00). You must manually apply the custom format 'h:mm' to the cell. Hours and minutes between two times (4:55). You must manually apply the custom format 'h' to the cell. Example Table 1 - Present the result in the standard time formatĬopy the following table to a blank worksheet, and then modify if necessary. Use the TEXT function to format the times: When you use the time format codes, hours never exceed 24, minutes never exceed 60, and seconds never exceed 60. In the Format Cells dialog box, click Custom in the Category list, and then select a custom format in the Type box.

On the Home tab, in the Number group, click the arrow next to the General box, and then click More Number Formats. You use the subtraction operator ( -) to find the difference between times, and then do either of the following:Īpply a custom format code to the cell by doing the following: There are two approaches that you can take to present the results in the standard time format (hours : minutes : seconds). Present the result in the standard time format There are several ways to calculate the difference between two times. Stay tuned and keep learning.Let's say that you want find out how long it takes for an employee to complete an assembly line operation or a fast food order to be processed at peak hours. We, the Exceldemy team, are always responsive to your queries. Please inform us in the comment section about your experience. Take a tour of the practice workbook and download the file to practice by yourself. In this article, I have tried to cover all the methods to subtract time and convert to numbers in Excel. Don’t forget to change the cell format from the “ Format Cells” feature to get the exact format you are looking for.įor practice, you can check the worksheet where we have added a sheet named “Practice”.Read More: How to Convert Degrees Decimal Minutes to Decimal Degrees in Excel In conclusion, we have successfully subtracted time and converted to numbers within a short time.Just hit ENTER and drag down the “ Fill Handle”.The time function will subtract 1 hour 30 min from the given time in cell ( C5).

Excel formula to subtract time