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

"Peo Sjoblom" wrote in message
...
=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



"Jill Johnson" wrote in message
...
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.