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
|