time data as number

[Gábor]

does anybody know some solution for the next:
I have a column with some time data on the next format (e.g.):
00:01:28 which means 1 minute and 28 seconds. I would like to see this data
expressed with numbers as 1,46 minutes.
are there a special cell format for this or could somebody suggest me some
other solution, using formulas?

thanks in advance

[Duke Carey]

Multiply the value by 1,440 (24 hrs/day*60 mins/hr)


"Gábor" wrote:

> does anybody know some solution for the next:
> I have a column with some time data on the next format (e.g.):
> 00:01:28 which means 1 minute and 28 seconds. I would like to see this data
> expressed with numbers as 1,46 minutes.
> are there a special cell format for this or could somebody suggest me some
> other solution, using formulas?
>
> thanks in advance
>
>
>

[Gábor]

Many thanks!

Great & Simply solution ;-)

"Duke Carey" wrote:

> Multiply the value by 1,440 (24 hrs/day*60 mins/hr)
>
>
> "Gábor" wrote:
>
> > does anybody know some solution for the next:
> > I have a column with some time data on the next format (e.g.):
> > 00:01:28 which means 1 minute and 28 seconds. I would like to see this data
> > expressed with numbers as 1,46 minutes.
> > are there a special cell format for this or could somebody suggest me some
> > other solution, using formulas?
> >
> > thanks in advance
> >
> >
> >