Clocking sheet time and date to a cell/ date like dd/mm/yy

  • Hi There,


    I try to make a clocking sheet, with time in and time out.

    It's almost working only I get the date and time in one cell and the date like mm-dd-yy.


    I like to split the time and date both to a cell date in C and time in D

    And by clocking in and by clocking out date to E and time to F


    The date I prefer to righten like dd-mm-yy.


    But I don't know how to it, does some one know and will help me?

    Files

    • Clocking.xlsm

      (39.84 kB, downloaded 83 times, last: )