Yes, I would love that too. I remember that issue, I even voted for it
twice (I log in as "Guraknugen")! I would vote for it again if it was
popssible... =)
My solution to the problem was to just enter time like 0928 and then
format the cells like 00":"00. When I need to use it for calculations, I
enter formulas in a colmn which I later hide. Often I write a formula that
translates my numbers to the smallest unit, in this case minutes, so 0928
will be translated to 9×60+28=568. If I want to sum these, I just sum the
calculated times in minutes in another hidden cell, then translates them
back to the 0928 format and then format that cell to 00":"00.
I am not sure about what the formulas will look like in English, since I
use Swedish version, but in some kind of pseudo code I guess it will look
somthing like this:
Cell A1: 0928, formatted to 09:28
Cell B1 (column B hidden when formulas are entered):
=60*int(A1/100)+A1-100*int(A1/100)
Or, which is the same thing but shorter: A1-40*int(A1/100)
Sum everything in column B, let's say the result is 12345 (minutes), and
that the sum is calculated in B100, then A100 could look like this:
=int(B100/60)*100+60*(B100/60-int(B100/60))
Or, again the same thing but shorter: =40*int(B100/60)+B100
Just replace "int" by whatever is the correct word to use for integer.
If we have things like 09:28:35.9734 it will be a bit more complicated but
of course not impossible.
By the way, I have my own recording studio at home and I sometimes need to
calculate time with the following format:
hh:mm:ss:ff.ff where f=frames. There can be 30 f/s, drop or non drop,
(USA, Japan etc), 25 f/s (here in Europe, maybe somewhere else too, I
don't know) or even 24 f/s. Maybe they could include frames in the time
format as well... but maybe too complicated since there are so many
different standards...
Johnny
Den 2006-02-08 15:53:58 skrev Randomthots <[EMAIL PROTECTED]>:
Glen wrote:
I am doing a spreadsheet and am trying to do what Microsoft calls
"masking" in a cell. I will give 2 examples
First example
I have a date cell and it is using the standard of 02/07/06 .
I want to make it so that when I start the cell I see the slashes and I
don't need to put them in and it goes from the 02 to the 07 without me
having to manually putting the slashes in.
Second example
I have a time cell that uses 09:28. I want to be able to put in 0928
and it separate it out without me having to put the : in manually.
This is probably in the help somewhere and I am just not seeing it
Thanks for your help
Glen
[EMAIL PROTECTED]
Nope. It's not in the Help because it's not something that Calc will do.
There is an open issue requesting this feature:
http://www.openoffice.org/issues/show_bug.cgi?id=47906
Personally, I don't find it that bad with dates because the slash key is
at least on the numeric keypad, but inputing time values is a big pain.
Not only is the colon not on the keypad but it's a *shifted* character
for the love of Pete!
I'll tell you what I usually do... if I'm creating a spreadsheet with a
time column, I'll just make separate columns for the hours, minutes, and
seconds and then a last column that combines it all using the time()
function. The syntax is time(hours;minutes;seconds).
But I wholeheartedly agree with you. And an enhancement like this should
be generalized so that you could use it for things like telephone
numbers, social security numbers, product codes, etc.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
