=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.