Use the AM/PM format for your start and end entries. If you're having
trouble entering them just remember that you have to type the colon to
separate the hour and minutes and after the minutes type a space before
typing the am or pm.

In your Hours cell to total the employees' hours you have to format it
with a custom format as [h]:mm

Use the formula that wjohnson gave you.

Now your boss will be happy with your Excel expertise and give you more
problems to solve ;-)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=500985