Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Good questions! Clearly I have not provided nearly enough information, so here goes:

1) The examples are uniform as I had to make an example document detailing the problem as the original document that sparked the need for the formula contains sensitive information/personal data that I am not at liberty to divulge/post on the internet. It would have been more work for me to hide said information than to make an example document. Plus in an example there is less clutter and I can use the whole spreadsheet to help explain what I am trying to achieve in the context of the spreadsheet itself.

The only difference in scope is that I want to add the time of more columns together, such as is detailed in this modified version of the original document I uploaded: C:\fakepath\Formula example modified.ods I figure that once I know how to change the formula contained within the cells at the end of each row to add the total of a second group of three columns, I can use that information to add a third/fourth/fifth etc, when/if needed. Please correct me if I am wrong.

In case you were wondering, the thick borders separating the cells into groups of three are only there to distinguish each group of hours/minutes/seconds.

2) My aim is to make a document that my clients can use to log time invested in certain activities, by entering the time in the empty cells (they will be empty upon completion; as you can see they each currently contain the number "1"). Each cell represents HOURS, MINUTES AND SECONDS, in that order. Once the client has entered in the relevant time info, I want the document to add up the total time at the end of each row and display the result (in the cells formatted HH/MM/SS). As you can see, I know how to do this using one group of three cells, but I can't seem to figure out how to change the formula to add the total of a second (or even third etc.) group of three cells. It's probably fairly simple, but as an absolute novice I can't figure it out without causing the formula to cease functioning correctly.

3) Yes I did choose HH:MM:SS (how did you make that show up in red by the way?) hopefully my long-winded explanation made it clear why.

As always I am grateful for your time, Mr. Jäger.

<in reference="" to="" lupp="">

Good questions! Clearly I have not provided nearly enough information, so here goes:

1) The examples are uniform as I had to make an example document detailing the problem as the original document that sparked the need for the formula contains sensitive information/personal data that I am not at liberty to divulge/post on the internet. It would have been more work for me to hide said information than to make an example document. Plus in an example there is less clutter and I can use the whole spreadsheet to help explain what I am trying to achieve in the context of the spreadsheet itself.

The only difference in scope is that I want to add the time of more columns together, such as is detailed in this modified version of the original document I uploaded: C:\fakepath\Formula example modified.ods I figure that once I know how to change the formula contained within the cells at the end of each row to add the total of a second group of three columns, I can use that information to add a third/fourth/fifth etc, when/if needed. Please correct me if I am wrong.

In case you were wondering, the thick borders separating the cells into groups of three are only there to distinguish each group of hours/minutes/seconds.

2) My aim is to make a document that my clients can use to log time invested in certain activities, by entering the time in the empty cells (they will be empty upon completion; as you can see they each currently contain the number "1"). Each cell represents HOURS, MINUTES AND SECONDS, in that order. Once the client has entered in the relevant time info, I want the document to add up the total time at the end of each row and display the result (in the cells formatted HH/MM/SS). As you can see, I know how to do this using one group of three cells, but I can't seem to figure out how to change the formula to add the total of a second (or even third etc.) group of three cells. It's probably fairly simple, but as an absolute novice I can't figure it out without causing the formula to cease functioning correctly.

3) Yes I did choose HH:MM:SS (how did you make that show up in red by the way?) hopefully my long-winded explanation made it clear why.

As always I am grateful for your time, Mr. Jäger.

<in reference="" to="" lupp="">*IN REFERENCE TO LUPP'S ANSWER*

Good questions! Clearly I have not provided nearly enough information, so here goes:

1) The examples are uniform as I had to make an example document detailing the problem as the original document that sparked the need for the formula contains sensitive information/personal data that I am not at liberty to divulge/post on the internet. It would have been more work for me to hide said information than to make an example document. Plus in an example there is less clutter and I can use the whole spreadsheet to help explain what I am trying to achieve in the context of the spreadsheet itself.

The only difference in scope is that I want to add the time of more columns together, such as is detailed in this modified version of the original document I uploaded: C:\fakepath\Formula example modified.ods I figure that once I know how to change the formula contained within the cells at the end of each row to add the total of a second group of three columns, I can use that information to add a third/fourth/fifth etc, when/if needed. Please correct me if I am wrong.

In case you were wondering, the thick borders separating the cells into groups of three are only there to distinguish each group of hours/minutes/seconds.

2) My aim is to make a document that my clients can use to log time invested in certain activities, by entering the time in the empty cells (they will be empty upon completion; as you can see they each currently contain the number "1"). Each cell represents HOURS, MINUTES AND SECONDS, in that order. Once the client has entered in the relevant time info, I want the document to add up the total time at the end of each row and display the result (in the cells formatted HH/MM/SS). As you can see, I know how to do this using one group of three cells, but I can't seem to figure out how to change the formula to add the total of a second (or even third etc.) group of three cells. It's probably fairly simple, but as an absolute novice I can't figure it out without causing the formula to cease functioning correctly.

3) Yes I did choose HH:MM:SS (how did you make that show up in red by the way?) hopefully my long-winded explanation made it clear why.

As always I am grateful for your time, Mr. Jäger.