Thanks Joe,
I knew that, but I read a post once that gave the path to the build
number somewhere in the menus or options. Much simply to go to the exe,
though.
As for the time, I did MM:SS and got hidden hours and remaining minutes.
I'll try with the brackets.
tc
Joe Conner wrote:
You can find the build (in windows at least) by locating soffice.exe,
right click on it, choose PROPERTIES, click the VERSION tab, click on
FILE VERSION. and the info will display in the right-hand window.
ALSO, you can add a user definition to the time choices. If you
define a display format as [MM]:SS and choose this for the cell format
then the total will display as 67:07.
Joe
Anthony Chilco wrote:
Hi Joe,
Of course, but Derek wants to display minutes only, not hours. so 40
minutes plus 30 minutes will give him 70 minutes, not one hour and
ten minutes.
tc
p.s. I'm using 2.0 as well. Do you know how to find the build? I know
it's buried deep in the menu somewhere but I've forgotten where.
Joe Conner wrote:
Not to be argumentative, if you simply format the cell as time
choose the 5th item down in the format column which shows "
876613:37:46 " it will give you a format of HH:MM:SS without formula
parsing or string ceations. This is the case with OOo v2.0 at least.
Joe
Anthony Chilco wrote:
Hi Derek,
Formatting the cells using mm:ss will display only minutes and
seconds. That is, hours are not displayed. In your example, you'd
still have to enter the hours i.e. 0:42:34. What will be displayed
is 42:34. In the second cell entering 0:24:33 will display 24:33.
Unfortunately, when you add them, the cell formatted mm:ss will
display 07:07. If you want to show the sum of the minutes, you'll
have to use a formula that parses the string into minutes and
seconds, does the addition, then creates a new string formatted the
way you want.
tc
Joe Conner wrote:
Input your time as 00:42:34 and 00:24:33 and then they will sum as
01:07:07.
Derek J. Carr wrote:
Hello,
Using OOo 2.0 on windows XP + SP2 (but it seems to be the same
in 1.1.4). This is my first time in trying to use calc to do
time calculations, and I'm having trouble with the formating.
I've looked at most of the user docs that I can find, and very
little is said about time formating. Basically I want a 'true'
format of MM:SS both for input and for output. So I'd like to
input "42:34" and have interpreted as 42 min and 34 sec, not 42
hours and 34 min - which is what it seems to be doing at the
moment and then just showing the minutes and seconds part. I'd
then like a cell to show 73:05 when added to a cell with 24:33. I
think this might be a bug. I looked at issue tracker, but it's a
complected item to search for.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
