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.