Forum Discussion
Conversion Question
Hello! I need some help with a conversion on Excel. I have a column with data that goes down 25 rows. The values in those cells consists of numbers and texts that display a length of time. For ex...
You can convert the durations into minutes in Excel using a formula that parses the hours and minutes from each cell and then calculates the total minutes. Here is a step-by-step guide on how to do it:
Split the text: If the text is in a consistent format (like "X hours, Y minutes" or "Y minutes"), you can use Excel's text functions to split the hours and minutes into separate cells.
Convert to minutes: after splitting the text, convert hours to minutes and add them to the minutes.
Handle cells with only minutes: ensure that cells with only minutes are handled correctly.
Split the text: If the text is in a consistent format (like "X hours, Y minutes" or "Y minutes"), you can use Excel's text functions to split the hours and minutes into separate cells.
Convert to minutes: after splitting the text, convert hours to minutes and add them to the minutes.
Handle cells with only minutes: ensure that cells with only minutes are handled correctly.