Sean Hi Sean,
You completely make sense in your observations about the master sheet and thanks for bringing this to our attention.
What happened there was: The transfer formatting function is not allowed when you have multiple files as a source, this means that the time format is not being transferred from the Employee sheet to the “Manager sheet” (let’s call the master sheet this way ;) )
To correct this, please, follow the steps below:
1) Select all columns
2) Go to FORMAT - NUMBER - CUSTOM DATE AND TIME
3) Pick up the time with this format, please and just click on apply.
All information should be fixed!!
Please, let me know if worked for you!