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+unsubscr...@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