Time is just regular numbers in Excel, you can add, subtract at your will.
Only thing you can't do if you use the default windows install is to display
it as negative values. It's easiest if you enter it as time that Excl can
recognize so if you put in half an hour you use 00:30:00 in the format of
hh:mm:ss

one day is 1 in Excel that means that one hour is 1/24 meaning that if you
enter 12:00 in a cell and change the format to general it will return 0.50

So you can just add up the time

=SUM(A2:A6)

if you sum all time values in A2:A5

if they can exceed 24 hours you might want to use a custom format like
[hh]:mm


--
Regards,

Peo Sjoblom





"Diane" wrote in message
...
I have found numerous time sheets on the web but they don't have what I'm
looking for. I want a sheet that calculates vacation and sick time. We
allow workers to take days, hours and minutes of time (usually no less than
30 minutes). I need to be able to enter these increments and have the
sheet calculate these per day, with time allotted, time taken and time left
for the month. For example: I need to know how much time a worker has
taken and have it calculate and display the number of days, hours and
minutes (if he has taken hours and minutes). I hope this makes sense to
someone who can help. Thanks, Diane