Microsoft KB Archive/104810

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:13, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q104810 to Microsoft KB Archive/104810 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.