Re: [libreoffice-users] Calculating hours using spin button - simplified

How do I get the spin button time results into a cell?


On 12/28/2016 10:46 AM, Paul D. Mirowsky wrote:
> 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