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.
Does anybody knows how to enter it so that it understand that is a length of time, and not a time of day?
Thanks.