time ???

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?

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?
>
>
>