Converting Standard Time format (hh:mm:ss) to number of minutes

Hello,

I need a little help in converting Standard Time format (hh:mm:ss) to number of minutes.

Ex. 1:54:00 -->114 minutes

Tried these formula but it didn't work.

A2
1:54:00


=hour(A2)+minute(A2)/60
=A2*24*60


Don't know what's wrong

try

=TEXT(A2,"[m]")+0

Originally Posted by Jonmo1

try

=TEXT(A2,"[m]")+0

It give's me this "276.00" (The cell is in Number format)

For that formual to return 276, then A2 must be 4:36:00

Originally Posted by Jonmo1

For that formual to return 276, then A2 must be 4:36:00

Sorry. just got confused! haha. It's all working now. That's the value that I'm trying to figure out.


Thank you so much!

You're welcome.