Hi All,
I have a big data in excel with the below data and i need to convert them in minutes. Examples below:-
1H 28M - 60minutes + 28minutes = 88minutes
1D 5H 54M - 24 hours (1440 min) + 5 hours (300 min)+ 54 minutes = 1794 min
Can someone help me what formula i can apply here?
I have a big data in excel with the below data and i need to convert them in minutes. Examples below:-
1H 28M - 60minutes + 28minutes = 88minutes
1D 5H 54M - 24 hours (1440 min) + 5 hours (300 min)+ 54 minutes = 1794 min
Can someone help me what formula i can apply here?