Ravi Sir's Cards › Excel
Freelance Timesheet in Excel (card 2 of 2)
Revision card 2 for Freelance Timesheet in Excel: Hours past midnight: =ROUND(MOD(D16-C16,1)*24-E16/60,2) gives 4.5; Amount: =G8*$B$3+H8*$B$3*$B$4 gives ₹6,150; Invoice total: =SUM(I7:I16) gives ₹46,275.
Read card text
What this card says
2 for Freelance Timesheet in Excel: Hours past midnight: =ROUND(MOD(D16-C16,1)*24-E16/60,2) gives 4.5
Amount: =G8*$B$3+H8*$B$3*$B$4 gives ₹6,150
Invoice total: =SUM(I7:I16) gives ₹46,275.
Learn this in the lesson: Freelance Timesheet in Excel: Hours Worked, Overtime and Invoice Total per Project