Your setup is a little confusing. It appears the person clocked IN twice at
the same time, clocked in and out at the same time. I don't know whatelse
you have in your speadsheet, but you might consider doing IN in one column
and OUT in the next column instead of both in the same column.

Here is the formula I used to calculate total hours worked (2 decimal place):
Here is my setup:
A1 = Date B1 = 8:00 (IN) C1 = 17:23 (OUT)
D1 = C1-B1 (9:23 in this example)
E1 = HOUR(D1) + (MINUTE(D1)/60) (9.38 hrs)

Maybe you can get what you need from this. Hope it helps.
Les

" wrote:

Is there away to go through excel and sum the only the total hours
that someone has worked for each day

The format that my excel worksheet is:

Name1
12/15/2007 0:41 | Out
12/15/2007 0:44 | Out
12/15/2007 0:44 | IN
12/15/2007 0:44 | IN
12/15/2007 16:11 | IN
12/15/2007 16:18| Out
12/17/2007 9:03 | IN
12/17/2007 12:27 | OUT
12/17/2007 12:51 | IN
12/17/2007 17:08| Out

Etc for all users the "|" represents the next column

In the last column I have calculated all if the times by using the
following formula in a Macro

=A4-A3+IF(A3A4,1)

But this gives me everything. Now I need to calculate just the times
that the person has worked throughout one day (it does not matter if
it is during a weekend; I just need the total hours)