# Hours to minutes - not getting expected result

#### Mel Smith

##### Well-known Member
On my spread sheet in cell R11 (and others), I have set up a formula to total up hours and minutes and this is working fine. R11 is formatted as [h]:mm as the total often exceeds 24. In cell T11 I am trying to convert the total in R11 to minutes by using the formula =HOUR(R11)*60 + MINUTE*(R11)/60 but I am not getting the expected result. Can anyone explain what is wrong, please? In this instance R11 = 25:00 and I expected T11 to show 1500:00 but instead it displays 1440:00

Mel

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

#### etaf

##### Well-known Member
multiply the time by 1440
No of Minutes in a day 24*60
and format the cell as a number

chemistry_v1.xlsx
QRSTUVWXY
10
1125:001500
12
13
14R11 = 25:00 and I expected T11 to show 1500:00 but instead it displays 1440:00
15
Sheet14
Cell Formulas
RangeFormula
T11T11=R11*1440

#### Mel Smith

##### Well-known Member
It's obvious when you see it!

Many thanks,

Mel

#### Peter_SSs

##### MrExcel MVP, Moderator
Can anyone explain what is wrong, please? In this instance R11 = 25:00
In relation to this question: 25:00 is one day and 1 hour, so your HOUR function will return 1, not 25.

#### Mel Smith

##### Well-known Member
Ah. Thanks, Peter

Mel

Cheers.

Replies
8
Views
386
Replies
5
Views
81
Replies
5
Views
220
Replies
3
Views
530
Replies
6
Views
740

1,136,644
Messages
5,676,967
Members
419,665
Latest member
allsmilees2

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