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

Hi,

I have two list of times in format HH:MM , :

TimeIn  TimeOut

07:29   15:08
07:20   14:00

for each pair I can compute its difference = (TimeOut-TimeIn)

It is also in HH:MM format so for firs pair it is 07:39

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 ?


TIA

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