How to introduce time lengths in an OpenOffice Calc spreadsheet?

D

david

Active member
Joined
May 11, 2008
Messages
2,148
Reaction score
0
Points
36
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.
 
Back
Top