| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
