OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Adding up hours and minutes

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
ReikiTeri
Newbie
Newbie


Joined: 29 Jan 2011
Posts: 3

PostPosted: Sat Jan 29, 2011 8:45 am    Post subject: Adding up hours and minutes Reply with quote

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 Rolling Eyes
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Jan 29, 2011 9:28 am    Post subject: Reply with quote

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 https://forum.openoffice.org
Back to top
View user's profile Send private message
ReikiTeri
Newbie
Newbie


Joined: 29 Jan 2011
Posts: 3

PostPosted: Sat Jan 29, 2011 12:04 pm    Post subject: Reply with quote

total jibberish to me i am afraid.
Back to top
View user's profile Send private message
apollothethird
General User
General User


Joined: 15 Jan 2011
Posts: 11
Location: Buffalo, New York

PostPosted: Sun Jan 30, 2011 2:06 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
ReikiTeri
Newbie
Newbie


Joined: 29 Jan 2011
Posts: 3

PostPosted: Mon Jan 31, 2011 2:43 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group