convert a custom Date Format to Minutes

%3CLINGO-SUB%20id%3D%22lingo-sub-2275731%22%20slang%3D%22en-US%22%3Econvert%20a%20custom%20Date%20Format%20to%20Minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2275731%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENeed%20your%20help%20with%20this.%20I%20need%20to%20convert%20the%20date%20in%20custom%20format%20to%20something%20workable%20but%20unsure%20how%20to%20do%20that.%20What%20formula%20could%20I%20use%20to%20extract%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20multipying%20by%201440%20seconds%20but%20still%20get%20the%20result%20in%20custom%20format%20with%20cologns%20which%20I%20can't%20sum%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EFormat%20of%20the%20original%20RAW%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hellofromagnes_1-1618568459387.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273287i4584C273A5025138%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hellofromagnes_1-1618568459387.png%22%20alt%3D%22hellofromagnes_1-1618568459387.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hellofromagnes_0-1618568442499.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273286iE978DAD8506582D7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hellofromagnes_0-1618568442499.png%22%20alt%3D%22hellofromagnes_0-1618568442499.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2275731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2275792%22%20slang%3D%22en-US%22%3ERe%3A%20convert%20a%20custom%20Date%20Format%20to%20Minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2275792%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1028196%22%20target%3D%22_blank%22%3E%40hellofromagnes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOption%201%3A%20change%20the%20number%20format%20to%20%5Bm%5D.%3C%2FP%3E%0A%3CP%3EYou'll%20see%20the%20number%20of%20minutes%2C%20but%20the%20underlying%20value%20will%20still%20be%20a%20date.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOption%202%3A%20in%20another%20cell%2C%20enter%20the%20formula%20%3DE2*1440%20and%20format%20the%20cell%20with%20the%20formula%20as%20Number%20with%200%20decimals.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi all,

 

Need your help with this. I need to convert the date in custom format to something workable but unsure how to do that. What formula could I use to extract it?

 

I tried multipying by 1440 seconds but still get the result in custom format with cologns which I can't sum

 

Any help would be appreciated.

 

Format of the original RAW

hellofromagnes_1-1618568459387.png

 

 

hellofromagnes_0-1618568442499.png

 

1 Reply

@hellofromagnes 

Option 1: change the number format to [m].

You'll see the number of minutes, but the underlying value will still be a date.

 

Option 2: in another cell, enter the formula =E2*1440 and format the cell with the formula as Number with 0 decimals.