Convert time number 9:30 to a whole number 9.5

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
 
K

Ken Johnson

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
 
M

Mais qui est Paul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculations Help 4
Converting standard time to decimal time 2
h:mm:ss formula 4
function to give the number of hours 3
How to add formulas together, hours & minutes function. 8
To find out the total number of hrs worked in a week 2
How do I convert a number into years and months if the numberrepresents months? 5
Convert Decimal fractions to binary and vice versa 1

Top