This will give you the time for John Doe
=SUMPRODUCT(--(C3:C14="Stop"),--(D3
14="John
Doe"),B3:B14)-SUMPRODUCT(--(C3:C14="Start"),--(D3
14="John Doe"),B3:B14)
Where B3:B14 are the times, C3:C14 are the status and D3
14 are the
employees
format as hh:mm:ss
--
Regards,
Peo Sjoblom
Thanks for your prompt response.
If the start time and end time are in rows, what would you do? For
example,
John Doe clocks in at 7:58 am and clocks out at 4:35 pm. The file has a
Start and Stop time mixed together depending on when the employee clocks
in
and out. Thanks.
Date Start/Stop Time Status Employee
9/17/08 6:35 am Start John Doe
9/17/08 6:41 am Start Allan Sheep
9/17/08 6:42 am Stop Steve Palmer
9/17/08 6:42 am Start Robert Conelly
9/17/08 4:35 pm Stop John Doe
9/17/08 4:36 pm Start Joseph Smith
9/17/08 4:37 pm Stop Robert Conelly
9/17/08 4:39 pm Stop Allan Sheep
9/17/08 4:45 pm Start Art Miller
9/17/08 4:48 pm Stop Joseph Smith
=B1-A1
format as hh:mm:ss
where B1 is end and A1 start
if there can be more than 24 hours use
[h]:mm:ss
as a format
--
Regards,
Peo Sjoblom
Is there a way to calculate the time quickly in Excel 2007? For
example,
the employee clocks in 7:58 am and clocks out at 4:35 pm. I want to
know
how many hours, minutes, and seconds between 7:58 am and 4:35 pm.
Thanks.