Could you tell us what is not working?
Are they real times or text looking like time ( left aligned if no forced alignment) ?
If so try TIMEVALUE(A1) instead of A1

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post