| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i convert a column of minutes into hours
I have a column of minutes in an excel spreadsheet which I want to convert
into hours and minutes as a decimal. i.e. I want to divide all the entries by 60. Is there an easy way of doing this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i convert a column of minutes into hours
In an empty cell, enter the number 60.
EditCopy. Select your minutes. EditPaste specialcheck Divide -- Kind regards, Niek Otten "Chrisj20" wrote in message ... I have a column of minutes in an excel spreadsheet which I want to convert into hours and minutes as a decimal. i.e. I want to divide all the entries by 60. Is there an easy way of doing this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i convert a column of minutes into hours
lets say A1 contains 500 (500 minutes) becasue time is a fraction of a day:
=A1/24/60 will yield 0.347222222 formatted as time will display as 8:20 -- Gary's Student "Chrisj20" wrote: I have a column of minutes in an excel spreadsheet which I want to convert into hours and minutes as a decimal. i.e. I want to divide all the entries by 60. Is there an easy way of doing this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| how can you convert hours into minutes? | Excel Worksheet Functions | |||
| Help for a newbie trying to add hours and minutes :) | Excel Discussion (Misc queries) | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
Linear Mode
