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

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]83:30:00[/TD]
[TD="align: right"]83.5[/TD]

</tbody>

excludelist​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B1[/TH]
[TD="align: left"]=A1*24[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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