| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add a column of time values eg 72hours plus 34hours 52mins
In excel I am trying to sum a column of time values
eg 5hours 3mins 6hours 35mins 76hours 58mins How can I do this in Excel, please help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to add a column of time values eg 72hours plus 34hours 52mins
If the times are formatted as hh:mm ( or [hh]:mm if hours 24), then use SUM
function with cell formatted as [hh]:mm. "David R" wrote: In excel I am trying to sum a column of time values eg 5hours 3mins 6hours 35mins 76hours 58mins How can I do this in Excel, please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to match values in one column to values in another? | Excel Worksheet Functions | |||
| Summing one column if two other columns' values appear in other sh | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
Linear Mode
