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






1 Reply


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.