Excel can calculate how many hours and minutes (the amount of time) it will take to complete two tasks. It can also take the start and end times for a task and calculate the elapsed time, which is the difference between the two times.
Sum time and format as hours/minutes/seconds. In Excel, you can sum up time first, and then format the result as you need. 1. Select a blank cell, and type =SUM(A2:B2) into it, and then press Enter key and drag the auto fill handle over the cells you need
In Excel, you can add the times first and then format the cells to hours/minutes/seconds. 1. Select a blank cell and type =SUM(A2:B2) , and then drag auto fill handle over the cells you need to apply this formula, see screenshot:
Post a Comment:
Showing 0 Comments: