Microsoft Office Tutorials and References
In Depth Information
3:00:00 PM
0.6250
4:30:00 PM
0.6875
6:00:00 PM
0.7500
7:30:00 PM
0.8125
9:00:00 PM
0.8750
10:30:00 PM
0.9375
Entering times
Like with entering dates, you normally don't have to worry about the actual time serial numbers. Just enter the
time into a cell using a recognized format. Table 6-3 shows some examples of time formats that Excel recog-
nizes.
Table 6-3: Time Entry Formats Recognized by Excel
Entry
Excel's Interpretation
What Excel Displays
11:30:00 am 11:30 AM
11:30:00 AM
11:30:00 AM 11:30 AM
11:30:00 AM
11:30 pm
11:30 PM
11:30 PM
11:30
11:30 AM
11:30
13:30
1:30 PM
13:30
11 AM
11:00 AM
11:00 AM
Because the preceding samples don't have a specific day associated with them, Excel uses a date serial number
of 0, which corresponds to the non-date January 0, 1900.
If you're using the 1904 date system, time values without an explicit date use January 1,
1904, as the date. The discussion that follows assumes that you are using the default
1900 date system.
Often, you'll want to combine a date and time. Do so by using a recognized date entry format, followed by a
space, and then a recognized time-entry format. For example, if you enter the following text in a cell, Excel in-
terprets it as 11:30 a.m. on June 18, 2013. Its date/time serial number is 41078.4791666667.
Search JabSto ::




Custom Search