Microsoft KB Archive/150746

Mac Works 4.0: How to Reference Cell for Hour, Minute, or Second

PSS ID Number: Q150746 Article last modified on 10-22-1998

4.0 4.0a 4.0b

MACINTOSH

================================================================ ==

The information in this article applies to:

 == Microsoft Works for the Macintosh, versions 4.0, 4.0a, 4.0b and 4.0c == 

= SUMMARY =

This article describes how to use the Hour, Minute, and Second functions to reference the hour, minute, and second portions of a cell formatted with the Time format.

= MORE INFORMATION =

The Hour function generates a serial number as an integer in the range from 0 to 23. The Minute function generates a serial number as an integer in the range from 0 t0 59. The Second function generates a serial number as an integer in the range from 0 to 59.

Example
If cell A1 contains the time 6:59:35 (or its serial number equivalent, 0.29137731481481481), the following functions result in the indicated values:

The referenced field must contain either a time value formatted with a Time format or a serial number formatted with the General format.

= REFERENCES =

For additional information, see the Microsoft Works 4.0 “User’s Guide,” Chapter 11, “Guide to Spreadsheet and Database Functions,” page 581.

= Additional query words: 4.00 4.00a 4.00b mac m_works mwksss =

Version : 4.0 4.0a 4.0b Platform : MACINTOSH Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.