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: [email protected]
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
