Microsoft Office Tutorials and References
In Depth Information
Time-Related Functions
Converting a year to roman numerals
Fans of old movies will like this one. The following formula converts the year 1945 to Roman
numerals: MCMXLV:
=ROMAN(1945)
This function returns a text string, so you can’t perform any calculations using the result.
Unfortunately, Excel doesn’t provide a function to convert Roman numerals back to Arabic
numerals.
Time-Related Functions
Excel, as you might expect, also includes a number of functions that enable you to work with
time values in your formulas. This section contains examples that demonstrate the use of these
functions.
Table 6-5 summarizes the time-related functions available in Excel. Like the date functions
discussed earlier, time-related functions can be found under the Date & Time drop-down list via
Formulas
Function Library.
Table 6-5: Time-Related Functions
Function
Description
HOUR
Returns the hour of a time value
MINUTE
Returns the minute of a time value
NOW
Returns the current date and time
SECOND
Returns the second of a time
TIME
Returns a time for a specified hour, minute, and second
TIMEVALUE
Converts a time in the form of text to an actual time value
Displaying the current time
This formula displays the current time as a time serial number (or a serial number without an
associated date):
=NOW()-TODAY()
You need to format the cell with a time format to view the result as a recognizable time. The
quickest way is to choose Home
Number
Format Number and then select Time from the
dropdown list.
 
Search JabSto ::




Custom Search