Hour, Minute, Second functions

[harrymul]

I use the hh:mm custom format for cells to enter start and end times. Then calculate time consumed by subtracting start time from end time (hh:mm).  I need to split the hours and minutes to calculate the total minutes. Using the hour and minute functions on the time consumed cell, returns 00:00. What am I doing wrong?

[#2]

@harrymul 

Hi, try this formula

[#3]

@PascalKTeam 

Perfect! Thank you very much PascalKTeam.

[#4]

No problem, happy to help. Would be nice if you could mark my reply as the official solution. Thank you!

[#5]

@harrymul 

Other way you may simply apply custom format to the result for elapsed time in minutes