Easiest is to use 24 hr clock 17:00-9:00
--
Don Guillett
SalesAid Software

"jgullett" wrote in message
...
I am needing to calculate time in Excel 2003. Say someone comes in to
work
at 9 AM and works until 5PM, how can I create a formula to automatically
count the total time worked?