• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract Minutes From a Large Number of Hours/Minutes/Sec

cyliyu

Member
I'm getting an error (#Value) when attempting to extract minutes from the largest number (Monthly Hours/Mins/Sec) and would appreciate some advice.
e.g. 10974:36:26 which I wanted to extract 36 out to perform some calculation. MINUTE formula will not works. Thanks.
Please see the attached file for a sample.
 

Attachments

  • ExtractMin.xlsx
    9.3 KB · Views: 5
Last edited:
Power query solution

Code:
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Sample with Error", Splitter.SplitTextByDelimiter(":", QuoteStyle.Csv), {"Sample with Error.1", "Sample with Error.2", "Sample with Error.3"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Split Column by Delimiter",{"Sample with Error.2"})
in
    #"Removed Other Columns"
 
Back
Top