Convert Day:Hour:Minute To Valid Times

We have a report application and developers that are giving us a real challenge.

1) if you have a cell formatted with:

DD:HH:MM and have a 4 digit numeric value for each section:
47.00:0.00:59.00
you can use the following formula to convert to hours minutes that excel can handle:
=(LEFT(P18,4))+MID(P18, FIND(":",P18)+1,4)/24+MID(P18, FIND(":",P18,7)+1,4)/1440

2) if you have a cell formatted with:
DD:HH:MM and have a 2 digit numeric value for each section:
47:00:59
you can use the following formula to convert to hours minutes that excel can handle:
=(LEFT(P4,2))+MID(P4, FIND(":",P4)+1,2)/24+MID(P4, FIND(":",P4,5)+1,2)/1440

Problem:
our developers have created a new report that now has a variable format
D:H:M
2:6:33
4:3:3
0:22:5
0:2:2
22:0:1..................