learningstatistics
Board Regular
- Joined
- Dec 3, 2015
- Messages
- 56
Hello,
I have cells that looks something like what is shown in column 1. I want to tell excel "Find the newest time (ie 12:07:35) and the oldest time (ie 12:07:33). So two formulas here. Then I want to subtract them.
<tbody>
</tbody>
Some of the cells have only one time like the one in column 1 row 3. If this is the case, I want excel to subtract this cell from itself. So, the answer would always be zero.
I appreciate any help.
Thanks
I have cells that looks something like what is shown in column 1. I want to tell excel "Find the newest time (ie 12:07:35) and the oldest time (ie 12:07:33). So two formulas here. Then I want to subtract them.
<colgroup><col></colgroup><tbody> </tbody> | ||||
15:25:55,15:25:55,15:25:55,15:25:55 | ||||
12:37:58 |
<tbody>
</tbody>
Some of the cells have only one time like the one in column 1 row 3. If this is the case, I want excel to subtract this cell from itself. So, the answer would always be zero.
I appreciate any help.
Thanks