There is a control named "DateField" writing to a cell named "DateField" There is a control named "TimeField" writing to a cell named "TimeField" There is a control named "CurrencyField" writing to a cell named "CurrencyField" etc. Each control has a "Text Modified" event which calls the macro. The macro checks if a cell has the same name as the calling control. If so, it writes an appropriate cell value into that cell. This is a dirty hack. It applies to single cells only, e.g. you can't fill columns of time data with this. I always recommend databases. Most spreadsheet users try to simulate databases in spreadsheets. Spreadsheet cells are NOT the normal target of form controls. The controls are made for database records where one control applies to all records of a whole column. -- View this message in context: http://nabble.documentfoundation.org/Calculating-hours-using-spin-button-tp4203752p4204604.html Sent from the Users mailing list archive at Nabble.com. -- 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