Hi,
I am trying to re-format a time punch into a new date column using a formula.
Currently there is a date column in the following format:
<tbody>
</tbody>
There is another column in the sheet with the clock in times which does not have the date in the proper format (example of dates shown below):
<colgroup><col></colgroup><tbody>
</tbody>
I would like to create a new column which combines both into the excel date formatting so I can input it into a different template.
Thanks so much for your help!
I am trying to re-format a time punch into a new date column using a formula.
Currently there is a date column in the following format:
01/01/17 |
<tbody>
</tbody>
There is another column in the sheet with the clock in times which does not have the date in the proper format (example of dates shown below):
158 |
0917 |
2042 |
<colgroup><col></colgroup><tbody>
</tbody>
I would like to create a new column which combines both into the excel date formatting so I can input it into a different template.
Thanks so much for your help!