How to count or calculate hours worked between times in Excel?
If you want to calculate your weekly working hours, firstly you need to know the total hours you worked each day. In this tutorial, we will show you how to count hours worked between times by using formula in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
For example you have listed Start time in cell range B11:B15, and the End time in cell range C11:C15, please do as follows to count hours worked between these times.
1. Click the cell D11, copy and paste formula =(C11-B11)*24 into the Formula Bar, and press Enter key. See screenshot:
Then you will get the total working hours of Date 2014/11/21.
2. Select cell D11, drag the fill handle down to the cell D15 to auto fill the selected cells. Now the total working hours for each date is counted out.