Hi jf,
Here are two examples, constructed in Numbers '09. Both are the same except for the use of duration values in the left table and numerical values in the right table. In the 'using durations' table, the values entered in column B are the same as those entered in column B of the 'using numbers' table, but include the h that tells Numbers these are duration values. Note that the duration including fractions of hours (3.5h, 4.75h and 8.33h) are displayed as hours, minutes (and seconds) by Numbers.
Formulas
Using Durations::D2: =DUR2HOURS(C2)/27
Using Numbers::D2: =C/27
You asked to "get the number of credits with two decimal( places)." You can get this visually by formatting the cell containing this value to DISPLAY the value rounded to two places after the decimal, but that affects only what is displayed—the cell still contains the full calculated value, and that value is what will be used in any calculations referencing that cell.
If you are using the result in further calculations, and you want the results to reflect the rounded value, then you'll need to ROUND the results. Here are the same formulas, enclosed in the ROUND function to round the result to two decimal places:
Using Durations::D4: =ROUND(DUR2HOURS(C2)/27,2)
Using Numbers::D4: =ROUND(C2/27,2)
In Numbers 3, the division operator ( / ) may be entered as a slash, but will display as a division sign ( ÷ ).
Regards,
Barry
PS: Some notes on QUOTIENT() and TIME()
QUOTIENT(dividend;divisor) accepts only numbers as arguments. Either or both of these numbers may include a decimal part, and the decimal part will be included in the calculations.The first number (dividend) is divided by the second number (divisor), and the whole number part of the result is returned. Either or both of the dividend and divisor may include a decimal part, and the decimal part will be included in the calculations, but any decimal part of the division will be ignored.
QUOTIENT(7;5) returns 1 and ignores the remainder (2)
QUOTIENT(5;7) returns 0 and ignores the remainder (5)
QUOTIENT(13.7;6.5) returns 2
TIME(h,m,s) converts separate values for hours, minutes, and seconds into a date/time value. In Numbers, 'time' always means 'time of day.' Any cell displaying a time of day actually contains a date/time value, as does any cell displaying a date (or part of a date—eg. Jan 5).
A date/time value is NOT a duration, which is the type of value used in the first table above.
A useful reference to most of the functions in Numbers 3 is the iWork 09 Formulas and Functions User Guide. Clicking the link will open a pdf copy of the guide, which can be read in a browser, or saved to your Mac and opened in Preview.
B
