| View previous topic :: View next topic |
| Author |
Message |
ReikiTeri
Newbie
Joined: 29 Jan 2011
Posts: 3
|
 Posted: Sat Jan 29, 2011 8:45 am Post subject: Adding up hours and minutes |
 |
|
I have no idea how to do this at all as never really used a spreadsheet before. Would not know where to start
Going to have 5 coloumns Name Date Start Finish Time.
I would like it to add up the time i have spent doing a reiki session with clients.
Cheers Teri  |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sat Jan 29, 2011 9:28 am Post subject: |
|
|
Add up the times and apply number format [HH]:MM
The [brackets] shows 1 day and 13 hours as 37:00 whereas the "normal" number format HH:MM would show 13:00 cutting off the 24 hours of a day.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
ReikiTeri
Newbie
Joined: 29 Jan 2011
Posts: 3
|
| Posted: Sat Jan 29, 2011 12:04 pm Post subject: |
|
|
| total jibberish to me i am afraid. |
|
| Back to top |
|
|
apollothethird
General User
Joined: 15 Jan 2011
Posts: 11
Location: Buffalo, New York
|
| Posted: Sun Jan 30, 2011 2:06 pm Post subject: |
|
|
| ReikiTeri wrote: | | total jibberish to me i am afraid. |
Do you know how to add any numbers at all?
Set the format of your time column for "Time", either HH:MM or HH:MM:SS. Use the adjacent column to convert the time to a number:
| Code: | | =HOUR(B2)+MINUTE(B2)/60 |
Then take the sum of this new converted column.
-- L. James
--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames |
|
| Back to top |
|
|
ReikiTeri
Newbie
Joined: 29 Jan 2011
Posts: 3
|
| Posted: Mon Jan 31, 2011 2:43 pm Post subject: |
|
|
| No i am afraid i know nothing about adding numbers etc at all. All very new to me. Sorry. Ta for helping much appreciated. |
|
| Back to top |
|
|
|
