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

Time calculation as percentage SOLVED

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


Joined: 27 Jul 2007
Posts: 21

PostPosted: Fri Oct 31, 2008 5:19 am    Post subject: Time calculation as percentage SOLVED Reply with quote

I am trying to work out a time calculation spreadsheet for my employees: eg. if a worker clocks in at 16:00 (in A1)and leaves at 23:15 (in A2), I need the formula that would give me 7.25 (as a percentage) in hours in A3. It's a pretty basic formula, I should imagine, but havent been able to find any help till now on the web.
Thanks


Last edited by iskender on Fri Oct 31, 2008 11:39 am; edited 1 time in total
Back to top
View user's profile Send private message
bobban
OOo Enthusiast
OOo Enthusiast


Joined: 02 Jan 2008
Posts: 172
Location: Australia

PostPosted: Fri Oct 31, 2008 5:28 am    Post subject: Reply with quote

If you mean as a percentage of 24 hours, so that 7.25 = 30.21%, try the following:

A1 = 16:00 (cell format as Time)
A2 = 23:15 (cell format as Time)
A3 = A2-A1 (cell format as Percentage)
_________________
nil sine labore
Back to top
View user's profile Send private message
iskender
General User
General User


Joined: 27 Jul 2007
Posts: 21

PostPosted: Fri Oct 31, 2008 6:07 am    Post subject: Reply with quote

Sorry, maybe I was a little unprecise. I just need the minutes as a percentage i.e 15 minutes =0,25. The hours should remain in hours.
Back to top
View user's profile Send private message
bobban
OOo Enthusiast
OOo Enthusiast


Joined: 02 Jan 2008
Posts: 172
Location: Australia

PostPosted: Fri Oct 31, 2008 6:23 am    Post subject: Reply with quote

Ahhhh ok, in that case:

A1 = 16:00 (cell format as Time)
A2 = 23:15 (cell format as Time)
A3 = HOUR(A2-A1)+(MINUTE((A2-A1))/60) (cell format as Number with decimals)
_________________
nil sine labore
Back to top
View user's profile Send private message
iskender
General User
General User


Joined: 27 Jul 2007
Posts: 21

PostPosted: Fri Oct 31, 2008 7:13 am    Post subject: Reply with quote

Thanks! Very much appreciated.
Back to top
View user's profile Send private message
bobban
OOo Enthusiast
OOo Enthusiast


Joined: 02 Jan 2008
Posts: 172
Location: Australia

PostPosted: Fri Oct 31, 2008 7:17 am    Post subject: Reply with quote

Welcome, please add [SOLVED] to the thread title.
_________________
nil sine labore
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