Convert Time to Decimal ?

Convert Time to Decimal ?

Hello ,

I have 2 columns in date format which I need the time difference between them. There are multiple ways to achieve the wanted result so this is not my problem . The problem starts after I have the time difference in mm:ss but I cannot convert it in number format (decimal) .

What I need is to be able to find  avg time, min/max etc. So I would really love a way to convert mm:ss in mm,ss (decimal).


Anyone knows how to achieve it?