[libreoffice-users] Re: calc - hours of work in a month

On 05.06.2013 19:19, Brian Barker wrote:
> At 18:43 05/06/2013 +0200, Adam Noname wrote:
> > I have two list of times in format HH:MM , :
> > [...]
> > Then I want to sum all differences. It is not hard = SUM(D2:D33) .  It
> > should be in [HH]:MM format to show good number of hours. My result is
> > : 149:43 .  I want to round it to full hours, which shlould be IMHO
> > 150 .  How can I do it ?
>
> The underlying value for your total is a simple numeric value, so the
> fact that your fraction of an hour is shown in base 60 (as minutes) is
> no complication.  This underlying value is in days, so you need to
> multiply by 24 to get hours and then to round that:
> =ROUND(Xn*24)
>
> I trust this helps.
>
> Brian Barker



= ROUND(SUM(D2:D33)*24)

but I get :

3600:00

I have also to change cell format to numer and then it works as expected

150

Thx

Adam


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted