convert a custom Date Format to Minutes

[hellofromagnes]

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

[#2]

@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.