Hours to minutes - not getting expected result

[Mel Smith]

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

Thanks for your help.

Mel

 

[etaf]

multiply the time by 1440
No of Minutes in a day 24*60
and format the cell as a number

chemistry_v1.xlsx
	Q	R	S	T	U	V	W	X	Y
10
11		25:00		1500
12
13
14	R11 = 25:00 and I expected T11 to show 1500:00 but instead it displays 1440:00
15
Sheet14

Cell Formulas
Range	Formula
T11	T11	=R11*1440

 

[Mel Smith]

It's obvious when you see it!

Many thanks,

Mel

 

[Peter_SSs]

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]

Ah. Thanks, Peter

Mel

 

[Peter_SSs]

Cheers.