# Convert Hours to Minutes

#### larryms

##### New Member
Can someone please help me with this problem. I would like to convert the hours 2:47 to a numeric 2.47 minutes.

Thank you

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
huh? I see no change...
2:47=2.47

go to format cells, custom hh:mm to hh.mm

Can someone please help me with this problem. I would like to convert the hours 2:47 to a numeric 2.47 minutes.

Thank you

With A2 housing 2:47 (hours:minutes), following up your topic title...

B2:

=A2*1440

formatted as General.

With A2 housing 2:47 (hours:minutes), following up your topic title...

B2:

=A2*1440

formatted as General.
Thank you. Now can you help me and explain what 1440 represents?

it is 24*60
number of mins in an hr.

Replies
3
Views
109
Replies
7
Views
165
Replies
2
Views
150
Replies
5
Views
164
Replies
2
Views
247

1,196,437
Messages
6,015,269
Members
441,883
Latest member
brendanatm

### 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