Hours worked calculator in Excel

This example will teach you how to create a simple schedule calculator in Excel. Cells containing formulas are colored light yellow.

1. To automatically calculate the next 4 days after the start date, use the formulas below:
   • For cell B6:

     =TEXT(C6,"dddd")

     =ТЕКСТ(C6;"дддд")

   • For cell C6:

     =C5+1

2. Select the cells containing the time.
3. Right-click on them, in the context menu select Format Cells (Cell Format) and set the correct time format. For cells R-12, R-13 и R-14 use the format circled in the figure below.
4. For daily automatic calculation of hours worked, as well as total hours and overtime, use the formulas below:
   • For range K5: K9:

     =(F5-E5)+(I5-H5)

   • For cell R-12:

     =SUM(K5:K9)

     =СУММ(K5:K9)

   • For cell R-14:

     =IF(K12>K13,K12-K13,0)

     =ЕСЛИ(K12>K13;K12-K13;0)