| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Minutes into Hours and Minutes
So if I have a cell with say 43,238 minutes, I would like to convert
into Hours and Minutes. thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Minutes into Hours and Minutes
Hi,
Suppose your data is in cell A1. Now type this formula in cell A2 =A1/60 Then select cell A2 and change the format of this cell to 'Time'. HTH, -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! " wrote: So if I have a cell with say 43,238 minutes, I would like to convert into Hours and Minutes. thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Minutes into Hours and Minutes
divide by (60*24) and format Custom as [hh]:mm
-- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... | So if I have a cell with say 43,238 minutes, I would like to convert | into Hours and Minutes. | | thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Minutes into Hours and Minutes
=A1/60/24 and format as [h]:mm
-- David Biddulph wrote in message ... So if I have a cell with say 43,238 minutes, I would like to convert into Hours and Minutes. thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Minutes into Hours and Minutes
Hi
Format the result cell, FormatCellsNumberCustom[h]:mm Use the formula =A1/1440 Excel stores times as fractions of a day, so divide by 60 then by 24 hence divide by 1440 -- Regards Roger Govier wrote in message ... So if I have a cell with say 43,238 minutes, I would like to convert into Hours and Minutes. thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert Minutes into Hours and Minutes
And have you checked the answer which that formula gives you, Pranav?
Either 15:12 or 17295:12 (depending on formatting) seem unlikely answers. Perhaps a further division by 24 may be worth trying? :-) -- David Biddulph "Pranav Vaidya" wrote in message ... Hi, Suppose your data is in cell A1. Now type this formula in cell A2 =A1/60 Then select cell A2 and change the format of this cell to 'Time'. HTH, -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! " wrote: So if I have a cell with say 43,238 minutes, I would like to convert into Hours and Minutes. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert total minutes to hours and minutes | Excel Discussion (Misc queries) | |||
| Convert Decimal hours and Minutes to minutes please. | Excel Worksheet Functions | |||
| How do I convert 184 minutes into 3:04 (3 hours:4 minutes) in EXCE | Excel Discussion (Misc queries) | |||
| How do I convert a number of minutes into hours and minutes? | Excel Worksheet Functions | |||
| Convert a number of minutes like 400 into hours and minutes | Excel Worksheet Functions | |||
Linear Mode
