Hi Derek,
I'm not sure what you mean. If you want to use the basic functions in
the file I sent, you can import them, but I think it's not really
necessary. If you use the format string '[MM]]:SS' you'll get minutes
only with the hours included. i.e. 43:36 plus 30:12 will give you 73:48.
The only problem is that you still have to enter the numbers as 0:43:36.
When only two numbers are entered, it's assumed that the seconds have
been left off, not the hours.
tc
Derek J. Carr wrote:
Anthony Chilco wrote:
Hi Derek,
I've attached a sample calc file with two basic functions. One writes
minutes and seconds in the format you want. The other takes that type
of string and converts it back to seconds. In order to get the
display you want, format the cells as 'text'. You'll be able to enter
minutes:seconds without having them change automatically to
hours:minutes.
tc
-----------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Thanks. Anthony, that's an interesting way of dealing with the
problem. I couldn't work out how to get the basic functions into the
input line though. It just ended up with text when I tried it.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
