convert a custom Date Format to Minutes

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.