Timeline for Convert duration in XXm, YYs format to time value
Current License: CC BY-SA 4.0
11 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Nov 2, 2023 at 10:53 | comment | added | Mayukh Bhattacharya | @SalmanA Sir glad to know it worked on your end! | |
Nov 2, 2023 at 10:52 | comment | added | Salman Arshad |
sumproduct it was
|
|
Nov 2, 2023 at 10:52 | vote | accept | Salman Arshad | ||
Nov 2, 2023 at 10:48 | comment | added | Mayukh Bhattacharya |
@SalmanA also change SUM() to SUMPRODUCT()
|
|
Nov 2, 2023 at 10:41 | comment | added | Mayukh Bhattacharya |
Please download to see oñ your end, probably you going to hit CTRL +SHIFT +ENTER while exiting the edit mode. Download
|
|
Nov 2, 2023 at 10:38 | comment | added | Salman Arshad | All I get is zeros: i.sstatic.net/88XGf.png | |
Nov 2, 2023 at 10:32 | comment | added | Mayukh Bhattacharya |
Those solutions works from Excel 2010+ onwards.
|
|
Nov 2, 2023 at 10:31 | comment | added | Salman Arshad | Sorry, it is not working in Excel 2016 | |
Nov 1, 2023 at 16:51 | history | edited | Mayukh Bhattacharya | CC BY-SA 4.0 |
added 12 characters in body
|
Nov 1, 2023 at 16:39 | history | edited | Mayukh Bhattacharya | CC BY-SA 4.0 |
deleted 3 characters in body
|
Nov 1, 2023 at 16:26 | history | answered | Mayukh Bhattacharya | CC BY-SA 4.0 |