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. -- ------------------------------------------------------------------------ To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] with Subject: help
