Forum Discussion
convert a custom Date Format to Minutes
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 14...
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.