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

"Metalteck" <Metalteck@discussions.microsoft.com> wrote in message
news:FBBCD963-03B9-4671-A643-593601DAFA31@microsoft.com...
> 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?

[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

"Niek Otten" wrote:

> I assume you mean 175 minutes.
> Format>Cells>Custom, in the Type box, enter [m]
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "Metalteck" <Metalteck@discussions.microsoft.com> wrote in message
> news:FBBCD963-03B9-4671-A643-593601DAFA31@microsoft.com...
> > 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?
>
>
>

[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

"Metalteck" <Metalteck@discussions.microsoft.com> skrev i melding
news:FBBCD963-03B9-4671-A643-593601DAFA31@microsoft.com...
> 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?