Adding Textbox with backgroundcolor in Gimp

duplicate the text layer (Create a textbox. It will end up being a layer) and, on the original layer, performing a "Layer->Discard Text Information" followed by a bucket fill ("Edit->Fill with FG Color"). 


Found at: http://www.gimptalk.com/index.php?/topic/36694-adding-a-background-color-to-a-text-box/

Um dann noch eine verwaschene Border dazuzutun:
Neues Bild, gerade so gross , wie es sein muss für die Textbox. Border kreieren, kopieren und ins Original einfügen.

Summing up time in OpenOffice

Summing hours and minutes (more than 24 hours)

Select the cells to sum; from the menu: Format - Cells...; Category = User-defined; Format code = [HH]:MM. You can now enter hours and minutes, for example 15:15, 25:30. Summing them gives 40:45, displayed correctly.

Summing minutes and seconds (more than 60 minutes)

Use the example for hours and minutes above, but pretend that you are entering minutes and seconds, rather than hours and minutes. So entering 15:15 means 15 minutes 15 seconds.

found on :https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Date_&_Time_functions

Formular to Convert Hours and minutes into  decimals

=(HOUR(E2)*60+MINUTE(E2))/60

found on http://www.oooforum.org/forum/viewtopic.phtml?t=36320