| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm trying to add time differences in h:mm:ss, but SUM won't work
any suggestions?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm trying to add time differences in h:mm:ss, but SUM won't work
In the future, keep your subjet line short, and post the majority of your
question in the body. SUM is used to add a range of cells together. If you want the time difference between two cells, simply subtract them, and format cells as h:mm:ss =A3-A2 or =TEXT(A3-A2,"h:mm:ss") Where A3 is the later time, A2 is the first/earlier time. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Emily" wrote: any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm trying to add time differences in h:mm:ss, but SUM won't work
seems this would require some more information. Are you summing more than 24
hours? If so, go to Format Cells and change to Custom formattiing, [h]:mm:ss "Emily" wrote: any suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm trying to add time differences in h:mm:ss, but SUM won't work
Maybe you just have to format the cell with the formula(s):
[hh]:mm:ss If this doesn't help, you may want to explain what's going wrong. Emily wrote: any suggestions? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm trying to add time differences in h:mm:ss, but SUM won't work
<won't work
How do you know? -- Kind regards, Niek Otten Microsoft MVP - Excel "Emily" wrote in message ... any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Format differences | Excel Worksheet Functions | |||
| Differences between values in two work sheets | New Users to Excel | |||
| Calculating differences in time. PLs Help | Excel Discussion (Misc queries) | |||
| Time differences in excel | Excel Worksheet Functions | |||
| time differences in a column | Excel Worksheet Functions | |||
Linear Mode
