| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to sum a column to equal hours and minutes in Excel?
Hi,
=Sum(A1:a100) formatted as [hh]:mm would do that. If it's not working in your case are you sure you have properly formatted times in your column? Mike "Kim" wrote in message ... I need to formulate a column to add time and convert it to hours and minutes. I have tried the Sum formula and then changed it to hours and minutes in the format cell area but it does not work. My results are 00:00. If anyone can help I would appreciate it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| Adding hours and minutes in a column | Excel Discussion (Misc queries) | |||
| converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
| how can I add cells in hours and minutes, eg 1.15 +1.45 to equal . | Excel Worksheet Functions | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
![Mike H[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
