Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
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
Thanks for your help.
Mel