Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Can anyone help with adding units of time in an Excel Spreadsheet?
I have two columns, each has a measured duration of time, and I need to add the two together (example B1 and B2) to get a total measurement of time. For example, the amount of time spent making green widgets added to the amount of time spent making red widgets. Please help! Thank you!
I either get #VALUE! or 0:00:00. For example, in C2 I have 6:22:43 and in D2 I have 0:09:46.
4 Answers
- steve_loirLv 79 years agoFavorite Answer
Make sure the cells are formatted as TIme and you use the right syntax, (HH:MM:SS), then you can just add them.
- 9 years ago
Check your Format Cells tools...make sure that you have your time selection for over a 24 hour period
or something else. For example, [H]:MM, formats your time entered over a 24 hour period.
Maybe, the use of a IF function can do help or create a formula that does the Ratio of the total time taken to make all widgets, but this is contingent upon how the time entered is formatted, thus back to square one.
BTW, are you entering "known", begin time and ending time, i.e., you know the exact time the widget production began and ended ?
- IXL@XLLv 79 years ago
Use the custom format [h]:mm:ss on all cells and then just add the two values
C1 =A1+B1 or C1 =SUM(A1,B1)
If wanting to total all subtotals use =SUM(C:C)
