time data as number
 

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

time data as number
 

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

time data as number
 

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