Saturday, March 19, 2011

yogi_ComputePayFromTimeSheet


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com


Chris1989 said:
How do I make my time sheet automatically calculate my total pay for the day. I have Time started in column C, Time stoped in column D, Total worked in column E, Pay rate in column F, and Daily total in column G. i am currently using formula  =ArrayFormula( IFERROR(D2:D - C2:C) ) in E2 and formula =ArrayFormula( IF(LEN(E2:E&F2:F) ; E2:E*F2:F ; IFERROR(1/0) ) ) in G2
-----------------------------------------------------------------------------------------
Here we go Chris ...