Is there a way to convert a time number: 9:30 (9 hrs 30 minutes)
to a whole (w/fraction, or one decimal to the left)? 9.5

Thanks You!
Wayne

On May 14, 12:00 pm, "WGD" <wgd.roam...@verizon.net> wrote:
> Is there a way to convert a time number: 9:30 (9 hrs 30 minutes)
> to a whole (w/fraction, or one decimal to the left)? 9.5
>
> Thanks You!
> Wayne

Multiply by 24 and reformat cell to General

Ken Johnson

Multiply by 24

A1 = 9:30 (h:mm)

=A1*24

Format as GENERAL or NUMBER

--
Biff
Microsoft Excel MVP


"WGD" <wgd.roaming@verizon.net> wrote in message
news:mJrWj.7883$Uz2.3414@trnddc06...
> Is there a way to convert a time number: 9:30 (9 hrs 30 minutes)
> to a whole (w/fraction, or one decimal to the left)? 9.5
>
> Thanks You!
> Wayne
>
>

Bonsour® WGD avec ferveur ;o))) vous nous disiez :

> Is there a way to convert a time number: 9:30 (9 hrs 30 minutes)
> to a whole (w/fraction, or one decimal to the left)? 9.5

Literally: How many hours in A1 (9:30)

=A1 /"1:"
format cell to General
9,50

by extension:
How many minutes in A1 (9:30)
=A1 / "0:1"
format cell to General
570

How many secondes in A1 (9:30)

=A1 / "0:0:1"
format cell to General
34200

HTH



--
--
@+
;o)))