Mac Works: Converting Time (H:MM) to Decimal (0.00) Hours
  
PSS ID Number: Q104810
Article last modified on 10-22-1998
 
3.0 4.0
 
MACINTOSH
 

======================================================================
-------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, version 3.0 and 4.0
-------------------------------------------------------------------
 
SUMMARY
=======
 
The following formula converts time from the hour:minute format to a
decimal equivalent in a Microsoft Works spreadsheet
 
   =(Time Reference-INT(Time Reference))*24
 
where "Time Reference" is the location of the number you want to
convert from colon format to decimal. It can be a cell reference or a
string of numbers.
 
For example, if you have "4:30" representing four hours and 30 minutes
in cell A1, the formula would read as follows:
 
   =(A1-INT(A1))*24
 
The result is "4.5".
 
KBCategory: kbother
KBSubcategory: macworkskb
 
Additional reference words: 3.00 mac m_eXcel mwksss hour minute h mm
h:mm
======================================================================
Version           : 3.0 4.0
Platform          : MACINTOSH
Issue type        : kbinfo
=============================================================================
Copyright Microsoft Corporation 1998.