Convert time number 9:30 to a whole number 9.5

  • Thread starter Thread starter WGD
  • Start date Start date
W

WGD

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
 
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
Click to expand...

Multiply by 24 and reformat cell to General

Ken Johnson
 
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
Click to expand...

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
 
Back
Top