Jambi46n2
Active Member
- Joined
- May 24, 2016
- Messages
- 260
- Office Version
- 365
- Platform
- Windows
Hello,
I was given a workbook with various sheets of data regarding timestamps. I need to total these in HH:MM:SS
The problem is in the first column Time was formatted in HH:MM, when it should look like the results entered manually on the right.
When I update the formatting from the home ribbon to convert to HH:MM:SS the results are incorrect.
Is there a formula that could perhaps populate the correct values on the right column?
Thanks much in advance!
I was given a workbook with various sheets of data regarding timestamps. I need to total these in HH:MM:SS
The problem is in the first column Time was formatted in HH:MM, when it should look like the results entered manually on the right.
When I update the formatting from the home ribbon to convert to HH:MM:SS the results are incorrect.
Is there a formula that could perhaps populate the correct values on the right column?
Thanks much in advance!
Time in HH:MM | Time Should Be HH:MM:SS |
0:01 | 0:00:01 |
0:14 | 0:00:14 |
0:24 | 0:00:24 |
0:02 | 0:00:02 |
0:30 | 0:00:30 |