locked
Time difference between to times RRS feed

  • Question

  • I'm trying to create an sign in and sign out sheet that enters the daily time and date you sign in. I also want when I leave for the end of the day it enters the time when out clock out. I want it to calculate the total hours worked, for example: if I sign in at 7:00 I get off at 3:30, because I get 30 minutes for lunch. I'm new to SharePoint and don't know how to get it started. Thanks
    Wednesday, April 8, 2015 2:07 PM

All replies

  • you can create a calculated/computed column to determine the difference between two dates (just use =[EndDate]-[StartDate])... but there is nothing in SharePoint that takes into account who will "get 30 minutes for lunch", or how those business rules would work.


    Scott Brickey
    MCTS, MCPD, MCITP
    www.sbrickey.com
    Strategic Data Systems - for all your SharePoint needs

    Wednesday, April 8, 2015 5:01 PM
  • Scott, what I'm stating is the working hours are for example; 7:00am to 3:30pm. I want it to record as 8 hours. how can I have the system automatically enter the end of my 8 hours or the time out clock out for work. Thanks
    Friday, April 10, 2015 11:29 AM