| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing all hours end of the month
hi
need little help here if somebody can show me the formula for total hours sample c1 12:30 c2 5:15 c3 4:25 c4 6:40 c6 then total hour i just can't add it up i tryed please help thank's |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
summing all hours end of the month
=SUM(C1:C4) and format the cell as [h]:mm (note the square brackets)
-- Ian -- "merlin's twin" <merlin's wrote in message ... hi need little help here if somebody can show me the formula for total hours sample c1 12:30 c2 5:15 c3 4:25 c4 6:40 c6 then total hour i just can't add it up i tryed please help thank's |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing hours and munites | Excel Discussion (Misc queries) | |||
| summing up hours spent on jobs | Excel Discussion (Misc queries) | |||
| Summing hours | Excel Worksheet Functions | |||
| Summing Hours and Minutes | Excel Discussion (Misc queries) | |||
| summing up hours | Excel Programming | |||
Linear Mode
