Trying to convert a time value into minutes. It can be in the format of 1:11:11 or 11:11:11 (hours minutes seconds). Or it can be in the format of 1.11:11:11 (days, hours, minutes seconds).

If no hour, this one works:

= IF(HOUR(G6)>0,HOUR(G6)*60+MINUTE(G6), MINUTE(G6)))

This works if there are hours

=(LEFT(G19,FIND(".",G19)-1))*1440+(MID(G19,FIND(":",G19)-2,2))*60+MID(G19,FIND(":",G19)+1,2)

But I can't come up with something that works for either case

Any ideas?
Thank you