If you have entered both the date and time, as you show, in a single cell,
then you can simply subtract the two and format as time to get the hours
worked.

As far as the subtotals are concerned, SUMIF will work for the totals by
employee.

If the starting times for each shift are identical for all employees (i.e.
20:00 for all), then you can use a formula like this (start times in column B,
end times in C, hours worked in column D):

=SUMPRODUCT((MOD(B1:B35),1)=20/24)*D1:D35)

If the times vary a bit, say between 20:00 and 21:00, you could try

=SUMPRODUCT((MOD(B1:B35),1)=20/24)*(MOD(B1:B35),1)<=21/24)*(D1:D35))




On Tue, 14 Jun 2005 09:47:14 -0700, Nen wrote:

I was wondering if anyone has a solution for calculating (in 24hr Format):
Total Shift Hours per employee when start of shift is: 6/13/05 20:00 ending
6/14/05 04:00.
AND
Once shift totals are calculated in a column, subtotal both employee weekly
hours and company man - hours per shift.