Support required please
New Member
- Joined
- Sep 26, 2023
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi
I’m struggling to solve my problem and hoping you can help. I’ve a column of names in one tab alongside a time (number format e.g 210) which can be given in seconds or hours but currently in minutes sitting in another column in the same tab associated with the respective name to the left, for example times in minutes to run the marathon. In another tab within the same workbook, again I have the same list of names but this time in a different order in one column, and I’m wanting to add the correct time alongside the correct name in a different column, but this time I need the time to be in time format HH:MM:SS. Hopefully this makes sense and someone may be able to help. Thank you
I’m struggling to solve my problem and hoping you can help. I’ve a column of names in one tab alongside a time (number format e.g 210) which can be given in seconds or hours but currently in minutes sitting in another column in the same tab associated with the respective name to the left, for example times in minutes to run the marathon. In another tab within the same workbook, again I have the same list of names but this time in a different order in one column, and I’m wanting to add the correct time alongside the correct name in a different column, but this time I need the time to be in time format HH:MM:SS. Hopefully this makes sense and someone may be able to help. Thank you