Hi Team,
I want to extract the days, hours and minutes from cell string value "0 Day(s) 3 hour(s) 39 min(s)" and multiply Day(s) with 1440 plus hour(s) with 60 plus min(s) and to get the sum of n number of cells..
Can anyone help with a formula or VBA to do this.. Attached file with details
I want to extract the days, hours and minutes from cell string value "0 Day(s) 3 hour(s) 39 min(s)" and multiply Day(s) with 1440 plus hour(s) with 60 plus min(s) and to get the sum of n number of cells..
Can anyone help with a formula or VBA to do this.. Attached file with details
Attachments

13.7 KB Views: 6