Sum work hours to hours & nearest 10th of an hour
Hi Howard,
Am Thu, 17 Jul 2014 00:35:07 -0700 (PDT) schrieb L. Howard:
On the active sheet that represents a given month of the year:
Column D = employee who has signed in
Column E = Date in
Column F = sign in time
Column G = Date out
Column H = sign out time
Sarah 7/16/2014 9:44 PM 7/16/2014 10:22 PM
Jaydee 7/16/2014 9:44 PM 7/16/2014 10:48 PM
Frank 7/16/2014 10:51 PM
Column M = A unique list of all employees.
do you need a macro?
you can use formula in N1:
=IF(G1="","",SUMPRODUCT(($G$1:$G$100+$H$1:$H$100-($E$1:$E$100+$F$1:$F$100))*($D$1:$D$100=M1)))
and copy down
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|