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:
 
   Function      Value
   -------------------
   =Hour(A1)     6
   =Minute(A1)   59
   =Second(A1)   35
 
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.