You may also want to have a look at some of the temples here
http://office.microsoft.com/en-us/re...ry=time+sheets

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Paul B" wrote in message
...
LV, Excel keeps time as a fraction of a day, multiply by 24 to get hours
in
decimal format, be sure to format the result as general or number


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"LV" wrote in message
...
Paul,

Thanks for your help, but all of those functions use the INT function,
which
rounds to the nearest integer.

Say some one come in at 8:45 AM, leaves for Lunch at 12:30, Returns at
1:00,
and leaves the office at 5:00 PM. I need to automate finding the amount
of
hours that individual worked (7.75) I know it seems lazy, but it would
help
me out in my daily tasks.

LV

"Paul B" wrote:

LV, excel will add and subtract time, see here for some help
http://www.cpearson.com/excel/datetime.htm#AddingTimes

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"LV" wrote in message
...
The INT and TEXT Functions are insufficent. I need to automate
filling
out
time cards for multiple people. INT only calculates whole hours and
TEXT
is
not summable.