convert hours into decimals

[nicasoft]

Hi Team,

I was wondering how to convert a hour cell into a decimal cell:


This cell: 83:30:00 into 83.5

why I do is divide the 30/60 min which will give me decimal, but I cant apply a formula to the whole cell since will divide the 83 also. I tried RIGHT and LEFT /60 and didn't work. I also didn't found any cell format that will give me what I want.

any clue which formula to use?

 

[Weazel]

i'm not sure i follow what your trying to describe....

but if i'm understanding what you want than maybe...

formatted as a number

Excel 2013

	A	B
1	83:30:00	83.5

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

excludelist​

Worksheet Formulas Cell Formula B1 =A1*24 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[MarkAMcCain]

Weazel is correct.

Format the hour cell as "time" and format the decimal cell as a "number" and A1*24 works.

 

[FDibbins]

What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Thu 08 Dec 2016) is actually 42712

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75