Your formula works if H3 is text but when it's a time the underlying value isn't 00:30:56 but the decimal equivalent, so your MID function doesn't work. Simpler just to multiply by 1440 (the number of minutes in a day), i.e. try
=H3*1440
....and format result cell as number
Bookmarks