Hours and Minutes to minutes

[mark hansen]

I have a column (M) that is a result of subtracting two date /time to get the elapsed time. The column (M) is formatted to [h]:mm and seems to displaying the correct Hours and minutes. When I sort of that column it goes from 0 hours 21 minutes to 3497 hours and 46 Minutes.

I want to convert the hours/minutes to a number that represents only minutes. I'm using the formula =(HOUR(M182)*60)+MINUTE(M182). It works until I get to 24 hours zero minutes. Instead of displaying 1440 (24 hours times 60), it displays zero. Even the formula =Hour(M182) where M182 is 24:00 displays 0.

How can I get the formula to work when the hours is 24 or above?

Thanks for any help,
Mark

 

[mark hansen]

Some additional information...

When the hours go up to 25 hours 7 minutes (for example) it displays 67 minues, completely disregarding the first 24 hours or 1440 minutes.

 

[shg]

Two ways:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

M​

[/td][td]

N​

[/td][td]

O​

[/td][td]

P​

[/td][/tr]
[tr][td]

1​

[/td][td]

0:21​

[/td][td]

3497:46​

[/td][td][/td][td]Format of M1: [h]:mm[/td][/tr]

[tr][td]

2​

[/td][td]

21​

[/td][td]

209866​

[/td][td]M2: =M1[/td][td]Format of M2: [m][/td][/tr]

[tr][td]

3​

[/td][td]

21​

[/td][td]

209866​

[/td][td]M3: =M1*1440[/td][td]Format of M3: General[/td][/tr]
[/table]

 

[mark hansen]

Thanks shg,

I used #2 I didn't think just formationg the out as [m].

I appreciate the help!
Mark

 

[shg]

You're welcome.