Hylton Conacher (ZR1HPC) wrote:
Hi Joe et. al,
Your spreadsheet works in that it displays the time etc correctly, however
can the time still be entered into the cell as a decimal format ie 0.3134 in
your example?
I tried formatting the cell HH: MM:SS and entering in a decimal and then
also changed the format of HHMMS to be HH.MMSS with no luck on either.
How could I enter the time value as a decimal ie h.mmss and have it reflect
as hh:mm:ss as well as doing all the calulations?
Attached is the file I use currently FYI
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
In Calc you can not enter digits and get it interpreted as anything but
integer. In case of an explicit percent formatting it is interpreted as
percent value dividing the integer by 100 (123 => 123% = 1,23
A database list can store time values in a more reliable and consitent
manner. So called pattern fields in forms can transform digits to dates
and times.
Example database with a time stamp field:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=22506&p=102636&hilit=pattern+field#p102636
Issue related to the general number formatter:
http://www.openoffice.org/issues/show_bug.cgi?id=89532
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
