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
![](https://i.imgur.com/4Cw1H0o.png)
2) Go to FORMAT - NUMBER - CUSTOM DATE AND TIME
![](https://i.imgur.com/YlDvml8.png)
3) Pick up the time with this format, please and just click on apply.
![](https://i.imgur.com/g0XO6fB.png)
All information should be fixed!!
Please, let me know if worked for you!