How do I convert time from hours and minutes to decimal time

Taryn,

There is a series of Duration functions that convert Durations to Numeric values. They are:

DUR2MILLISECONDS

DUR2SECONDS

DUR2MINUTES

DUR2HOURS

DUR2DAYS

DUR2WEEKS

If, say, your Duration format is Hours and Minutes, you could use =DUR2HOURS(hours and minutes duration) to make the conversion to decimal hours.

Jerry

Hi Taryn,

I can't see much from the photo, but I assume your formula is similar to the one I've used below:

The same formula is used in F4 and F6, and both return the same result (shown in F4).

F4 was left on "automatic" cell format, and the column widened to accomodate the repeating decimal to the point where Numbers would begin displaying zeros.

F6 was formatted as shown in the Cell Inspector to show only two decimal places.

Neither of these is an "exact" decimal, as it is not possible to use a decimal fraction to "exactly" represent 1/6 (or 10/60).

The likely reasons for yours showing a whole number of hours is a difference between your formula and the one shown in the example here, or a difference in the number of decimal places set in the cell's format.

Regards,

Barry

PS: To take a screen shot:

Place the mouse pointer at the top left corner of the area you want to nclude in the shot.

Press shift-command-4.

Use the mouse to drag a selection rectangle contining the part of the screen you want to include.

Release the mouse button. (You'll hear the sound of a camera shutter 'snapping' the picture.)

The screen shot will be saved to your desktop with the name 'screen shot' followed by the date and time.

The image may be posted to the discussion using the same steps you used to post the photo above.

B.

Taryn,

Apple has produced a great Numbers User Guide. You can download it from a link in the Help menu.

The first four chapters a good reading for new users.

Jerry