| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding cells
In a spread sheet I have a group of cells, b4 thru b34 that represent
minutes but are entered as single digits. Example - b4 = 35, b5 = 15, b6 = 55 and so on. The entry cells are formatted as custom - 00. That way if I have an entry of 5 or 0 it will read 05 or 00. I need a formula that will give me the total of all these cells and convert it into minutes. If I have a total of 285 it should read 45 as in :45. I have tried sum(b4:b34)/60 but it doesnt work on any formats. What would be a good solution if there is one. Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding 2 cells only if one is not over | Excel Discussion (Misc queries) | |||
| Need help w/ adding cells and dividing SUM by number of cells | Excel Worksheet Functions | |||
| Adding cells | Excel Discussion (Misc queries) | |||
| Adding only cells with an X in it | Excel Discussion (Misc queries) | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
Threaded Mode
