Ravi Sir's Cards › Excel
Freelance Timesheet in Excel (card 1 of 2)
Revision card 1 for Freelance Timesheet in Excel: Hours worked: =ROUND(MOD(D7-C7,1)*24-E7/60,2) gives 7.75; Regular hours: =MIN(F7,8) gives 7.75; Overtime hours: =MAX(0,F8-8) gives 1.5. Includes an example data table.
Read card text
What this card says
1 for Freelance Timesheet in Excel: Hours worked: =ROUND(MOD(D7-C7,1)*24-E7/60,2) gives 7.75
Regular hours: =MIN(F7,8) gives 7.75
Overtime hours: =MAX(0,F8-8) gives 1.5. Includes an
Example
data table
Learn this in the lesson: Freelance Timesheet in Excel: Hours Worked, Overtime and Invoice Total per Project