Reply to thread

Message: <blockquote data-quote="david" data-source="post: 2392339" data-attributes="member: 207029">I am trying to introduce time length of certain events in a spreadsheet in OpenOffice Calc, but I am faced with a problem: It reads it as time of day. Say that I write '2:23', for what I need, this means that the event I am measuring lasts 2 minutes and 23 seconds, but as soon as I write it and press enters, the program automatically changes it to 02:23:00 AM, and if I write something like 14:35, it changes it immediately to 02:35:00 PM. Does anybody knows how to enter it so that it understand that is a length of time, and not a time of day?Thanks.</blockquote>