[libreoffice-users] Calculating hours using spin button

In Calc, I have several Time fields using the spin button.

They are attached to the cell.

The format of the cell is set to Time HH:MM:SS

When entering data in to the cell directly without the spin button, 
subtracting one cell from the other gives me a number of hours.

12:00:00 - 11:00:00 = 01:00:00

When referencing the cells where the spin buttons are for the formula, 
there is no result.

How do I write the formula or make the cell value work with 'time' spin 
buttons?

Properties: Time Field

            Spin Button............Yes

            Time Format..........13:45:00

            All others at default.

Win 7 Pro, X86, LibreOffice 5.2

Thanks

Paul


--
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