Dear all,
I have a file that is a monthly time logbook. Each sheet is a day of the month (except the first sheet that has different information).
Then, I am using a macro that goes through the sheets on the workbook corresponding to each day of the month, collects the data and pastes it on a new sheet (named "Master", gathering all the information there.
In the daily sheets, three of the columns are realted to time and have the format h:mm
"time in" (col D)
"time out" (col E)
"Hrs:Min" (col G = E-D).
I would like that the new columns D, E and G with the pasted data on the "Master" sheet had the same time format. How do I do that?
Thank you in advance for any help.
Here is the complete code of the macro:
Bookmarks