# convert hours into decimals

#### nicasoft

##### New Member
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?

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

#### Weazel

##### Well-known Member

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

formatted as a number

Excel 2013
AB
183:30:0083.5

</tbody>
excludelist

Worksheet Formulas
CellFormula
B1=A1*24

</tbody>

<tbody>
</tbody>

#### MarkAMcCain

##### New Member
Weazel is correct.

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

#### FDibbins

##### Well-known Member
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

Replies
3
Views
183
Replies
6
Views
413
Replies
2
Views
169
Replies
2
Views
174
Replies
7
Views
509

1,191,719
Messages
5,988,295
Members
440,148
Latest member
sandy123

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back