Re: [libreoffice-users] calculating time differences

On Mon, 31 Dec 2012 16:20:23 -0300
"Daniel A. Rodriguez" <daniel.armando.rodriguez@gmail.com> wrote:

Hello Daniel,

> I need to calculate several videos duration having initial and final
> time in hh:mm:ss.000 format. But even if such format is set as a custom
> one just got a #VALUE! message.
> Is possible to achieve that task or need to look for an alternative way
> to find out?

Tried it here, and it works for me.

> From the help pages an error of #VALUE indicates; The formula yields a
value that does not correspond to the definition, or a cell that is
referenced in the formula contains a text string instead of a number.

So, ensure your cells are all of the custom time type, and you're not
entering, for example, o(oh) or O(OH) instead of 0(zero).

-- 
 Regards  _
         / )           "The blindingly obvious is
        / _)rad        never immediately apparent"
White people going to school, where they teach you to be thick
White Riot - The Clash

-- 
For unsubscribe instructions e-mail to: users+help@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