LV

See Chip's Overtime pages for more on your task.

http://www.cpearson.com/excel/overtime.htm

Gord Dibben Excel MVP

On Fri, 10 Dec 2004 14:47:03 -0800, "LV" wrote:

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.