time ???

[Metalteck]

If i have a time formatted as 2:55 hrs, how can I convert this to just a
total of minutes, for example 2:55 = 135 minutes?

 

[Niek Otten]

I assume you mean 175 minutes.
Format>Cells>Custom, in the Type box, enter [m]

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Harald Staff]

Multiply it by 1440 and format the result as a decimal number.

(Because there are 1440 minutes in a day. You knew that ;-)

HTH. Best wishes Harald

 

[JoAnn Paules - MVP Publisher]

I do NOT want a job wherever he works. Work 2 hrs and 55 minutes, get paid
for 2 hrs and 15 minutes? Not me.

JoAnn Paules
MVP Publisher

I assume you mean 175 minutes.
Format>Cells>Custom, in the Type box, enter [m]

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

If i have a time formatted as 2:55 hrs, how can I convert this to just a
total of minutes, for example 2:55 = 135 minutes?