Thread: How to format a immense information in excel 2007 date and time

They are currently in Excel 2007, covers a huge databases, the purpose is formed three columns, date created, date modified, date added Last. Each cell has values below each column indicates the significance. I do not mean that they are able to easily remove the time-value of the beginning of each cell and the cell format to date format I will be able to solve easily. Several ideas on how to do it. I appreciate your help.

If these cells in a sample of "values", when in the past include the date format, the lens can be ordered. You can highlight the three columns, and will revolutionize the form of different date format If you prevail in a short form. If the cells are essentially contains the "text", then do not do these things to give you what you are giving the impression of.

Sometimes, most of the information required to maintain records of the order and the top position, this file is an Excel database. Whether it's individual record of telephone numbers, a contact list of the members of an organization or group, or a collection of coins, cards or books, the database file in Excel to create a solution that is easy to write, store and find information, order. Excel has built in tools to maintain and track data to find specific information when you want.

At the time, a function that provides the current time and the internal clock of the data base system. You can use the function at the time-to-date and time on the worksheet. A similar function today, at the moment does not make any argument, and is still mechanically every time you open the spreadsheet. When you type currently operating in a cell, Excel positions the day before the current time. It also formats the date using the date format and time to 24 hours.

After identifying the time argument, using a series of 0 and 23 connecting several numbers higher than 23 divided by 24 and residues are used as the time value. When setting the minute and subsequent arguments, using a serial connection 0 to 59 minutes several arguments greater than 59 was rehabilitated in hours and minutes, for the moment that many second argument is greater than 59 was rehabilitated in minutes and second.