Convert 00:00:00 to a plain number

[xadamz23]

Hello,

Im trying to convert time in 00:00:00 format to total number o
minutes. For example if I had 00:30:00, I want it converted to 30. I
I had 01:30:00, I want it converted to 90.

Is there a way to do this?

Thanks in advance,
Ada

 

[Frank Kabel]

Hi
use
=A1*24*60
and format this resulting cell as number

 

[ElsiePOA]

Assuming 01:30:00 is in cell A1, enter the following formula in A2:
=LEFT(A1,2)*60+MID(A1,4,2

 

[xadamz23]

Thanks guys,

That was much easier than I thought