On Thu, 24 Feb 2005 13:07:08 -0800, "Greg" wrote:

what is the formula for adding time?
For example, I would like my timesheet to automatically add the time I
worked by
adding the time I arrived to the time I left and put the amount of hours in
a total
column. In other words I would like to enter 9:00 AM and 5:00 PM and have
the
total show 8.

thanks in advance
Greg

Assuming you don't work past midnight, then:

=EndTime - StartTime

and format the result as h.

If you want hours and minutes, then format the result as something like:

h:mm


--ron