Den 2011-02-28 10:00:54 skrev Amichai Rotman <[email protected]>:
Hello,
I have a Calc spreadsheet I use to keep track of time, kind of a time
card.
I use the 24 Hrs. format. I have a Sheet for each client for the current
month (so it would include 31 rows maximum, not including the first one
used
for the headers):
Column A has the Start Time (i.e.: 09:15)
Column B has the End Time (i.e.: 13:25)
Now, I want Column C to have the total time for each row, and another
cell
to have the total time spent for this client that month (say, H3)
I guess I'd have to sum the total for C2:C32, but I can't figure out how
to
calculate it as time and what to put as a formula in H3.
Thanks!
Amichai.
You just sum as usual. Format the result as time, for example HH:MM or
[HH]:MM.
One hour is defined as 1/24 of a 24 hour period (”dygn” in Swedish… does
other languages also have a word for this? English seems to lack one…), so
8 hours=1/3≈0.3333…
If you enter 12:00 into a cell, it will probably display like that, but if
you then format it as 0.000 it will display as 0.5. I just mentioned this
so that you will easily realise that you can just sum and subtract times
like all other kinds of numbers. Things like =B3+B4-B5 will give an
expected result if B3:B5 contains time data, for example.
--
Kind regards
Johnny Rosenberg
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
