Working with Time

[Diane]

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

 

[Peo Sjoblom]

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

 

[DaveO]

Hi, Diane-
You may find it useful to reconsider how employees accumulate time
off, and how they spend it. Companies I've worked for express vacation
in terms of hours- if you get 10 vacation days per year, that's 10
days times 8 hours per day = 80 vacation hours. If you express
everything in a single time unit you will avoid converting back and
forth, as well as testy little arguments about what constitutes a
"day", for instance. (You could also easily divide by 8 to convert
hours to work days.)

Is that a possibility?

Dave O