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?


    • Clocking.xlsm

      (39.84 kB, downloaded 94 times, last: )