|Access||Adobe photoshop||Algoritmi||Autocad||Baze de date||C||C sharp|
|Calculatoare||Corel draw||Dot net||Excel||Fox pro||Frontpage||Hardware|
|Php||Power point||Retele calculatoare||Sql||Tutorials||Webdesign||Windows|
|Asp||Autocad||C||Dot net||Excel||Fox pro||Html||Java|
Most of the standard number formats are fairly self-explanatory, but the Date and Time formats may require a bit of explanation.
To help you understand how they work, do the following:
Can you figure out why this happened?
Excel assigns a numeric value to each date you enter so that it can create formulas that use dates. For example, you could write a formula that determined what a certain date would be that was a certain number of days before or after the entered date. It starts with 1/1/1900 as its baseline, or 1. Every other date is stored as a number that represents the number of days between it and 1/1/1900. So, for example, 12/31/1900 would be 366. (It was a leap year.)
Now try converting your birthday to a general number format:
In real-life usage, you seldom need to change between dates and general numbers, so this exercise is just to help you understand what's going on behind-the-scenes.
What about times? To answer this question, do the following:
Figure 4-7: Select a time format. The bottom two choices show the date as well.
The number 1.55 changes to 1/1/00 13.12. As this experiment indicates, the numbers to the right of the decimal point represent time. The 1 to the left of the decimal still represents 1/1/1900, and the 55 represents 55 percent of the time between midnight and midnight: 1:12 PM, or 13:12 on a 24-hour clock.
This experiment is useful mainly so that you understand how Excel deals with dates and times as numbers; in reality, you'll nearly always be entering dates and times in their normal format, such as 12:30 PM or 13:30:05.
Politica de confidentialitate | Termeni si conditii de utilizare|