Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I convert 281 minutes to 4h21m in excel
I want excel to add multiple lots of minutes each in different cells, then
show the total in hrs and minutes instead of 281 minutes. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I convert 281 minutes to 4h21m in excel
On Wed, 15 Mar 2006 18:04:27 -0800, tomtrish
wrote: I want excel to add multiple lots of minutes each in different cells, then show the total in hrs and minutes instead of 281 minutes. That you can do. =SUM(lots_of_minutes)/1440 Format as [h]:mm Note that 281 minutes is 4h41m, not 4h21m. --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I convert 281 minutes to 4h21m in excel
put 281 in A1 and in another cell:
=A1/24/60 to display 0.195138889 format as hh:mm to display 04:41 -- Gary''s Student "tomtrish" wrote: I want excel to add multiple lots of minutes each in different cells, then show the total in hrs and minutes instead of 281 minutes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text entered as minutes/seconds to minutes | Excel Worksheet Functions | |||
I need to convert 157.25 minutes, into hours, minutes and seconds. | Excel Discussion (Misc queries) | |||
Convert total minutes to hours and minutes | Excel Discussion (Misc queries) | |||
How do I convert 184 minutes into 3:04 (3 hours:4 minutes) in EXCE | Excel Discussion (Misc queries) | |||
Convert a number of minutes like 400 into hours and minutes | Excel Worksheet Functions |