| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pie PivotChart loses data label every time i swich page value | Charts and Charting in Excel | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| unmet challenge | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Linear Mode
