I wish to extract the hours, minutes and seconds from a duration time stamp for example: 114:35:10
If such a duration is inserted into a cell, excel places a date stamp prior to it.
When I attempt to use:
Hour(string) or format(string, “[h]:mm:ss”) the result is incorrect.
I also want to be able to extract the mm and ss values.
Can an expert please help.