Times

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Times

Introduction

A time is a decimal number that represents a fraction of a day. Unlike a date whose starting point can depend on various factors, a time is usually stated to start on a non-spatial point called midnight.

Like a date, a time is represented with a combination of numbers and special characters. Like a date, the character used depends on the language you are using. The character used can be checked in the Regional Settings of Control Panel in the Time property page:

Time

 To represent time, a day is divided into 24 non-spatial fractions and each of these fractions is called an hour. Each hour is divided into 60 fractions and each fraction is called a minute. The minutes are counted from 0 to 59. Each minute is divided into 60 fractions and each fraction is called a second. The seconds are counted from 0 to 59. Each second in divided into 1000 fractions and each fraction is called a millisecond. The milliseconds are counted from 0 to 999. The milliseconds are hardly used, only in extreme mathematically-oriented operations. To separate the sections of a time, you use a special character. In US English, that character is the colon. Therefore, 8 o'clock can be represented as 8:00

There are two ways to represent a time in a day. First, a day with light is divided into two sections. The first part is called morning. The other part is called afternoon. The period that divides them is called noon. One way you can represent a time, also called the military standard, counts the hours from 0 to 23. Using this technique, any time before 10 is represented with a leading 0. A time commonly called "8 o'clock" or "8 in the morning" is represented as 08:00. An equivalent time in the second part of the day is represented as 20:00. Using this military time, you don't actually don't indicate whether the time occurs in the morning or in the afternoon. The time stated provides complete information. The other technique of representing time consists of formally indicating in which part (also called a quadrant), the time period occurs. Using this technique, the first part of the day is represented with am, Am, or AM. This first part is counted from 0 to 11. Therefore, to indicate that the time occurs in the morning, after stating the time, you add an empty and type the two characters. An example is: 8:16 AM. The second part of the day is represented with the combination pm, Pm, PM. The hours of this part are also counted from 0 to 11. To indicate that the time occurs in the afternoon, after stating the time, you add an empty and type the two characters. An example is: 8:16 PM.

Microsoft Excel recognizes all the rules of time representation. Since there can be different scenarios to represent a value, it lets you customize how your time should appear.

Date and Time Combination
 
Introduction


In some circumstances, you may want a date and a time value values to be considered as one entity. This is possible.

To get the current date and time with one call, you can use the NOW() function. This function returns a value in the formula M/D/YYYY HH:MM.