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
    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