This will take us to the Format Cell windows. From there, select Format Cells, as shown below.
For this, select the cell in Total Time Taken column D and click right on it to get the menu list. Now we need to convert this subtracted time to see how much time is the actual and real difference. Now separate the time with a minus (“-“), which will subtract the time as shown below.ĭrag or copy the applied formula to below respective cells as shown below.Īs we can see in the above screenshot, each start and end time difference is coming as the time shows in the clock considering AM/PM. And select the time in column C first, and then select the select time in Column B. Now, we need to calculate the time taken to complete tasks.įor Subtracting Time in Excel, go to the cell where we need to see the output of subtracted time and type the “=” sign (Equal). Below is the table where for 3 tasks, for start time is mentioned in column B, and the end time is mentioned in column C.
