Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Do you mean that you want to add up (sum) all the hours and minutes
from this column? I'm not sure why you would want to do this, but you could enter this formula somewhe =sum(A1:A70) and then select the cell and Format | Cell | Number (tab), scroll down to Custom and enter [h]:mm as the format. This will give you total hours in a form like 37:55 (i.e. it does not wrap at 24 hours) I hope this is what you want - post back if not. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cells with time format and calculating the diffrence | New Users to Excel | |||
Calculating Time difference based on a condition | Excel Discussion (Misc queries) | |||
Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
Calculating negative time & creating scrol bars for fixed size txt box. | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions |