OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

time typing

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
416eddie
Newbie
Newbie


Joined: 11 Apr 2010
Posts: 1

PostPosted: Sun Apr 11, 2010 8:50 am    Post subject: time typing Reply with quote

i have a lot of times to type into a spreadsheet and i want to be able to type in 2129 and have it display as 21:29 , i want to save time having to type in the : between the number but when i format the cell for time when i type in 2129 it displays as 00:00 no matter what i type.any help on how i can get this done to save a lot of time...any help would be appreciated ..thanks
Back to top
View user's profile Send private message
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Sun Apr 11, 2010 9:50 am    Post subject: Reply with quote

http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=21753
_________________
OpenOffice 4.0.0 and LibreOffice 4.x.x on Fedora 20, Ubuntu 13.10, Windows 8.1 Preview (Triple Boot)
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Apr 11, 2010 9:53 am    Post subject: Reply with quote

http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=22506
and attachment http://user.services.openoffice.org/en/forum/download/file.php?id=5432 therein
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group