0
0 Comments

I’m looking for some guidance or references to implement a requested change in our part-time employee timesheet (Shown below)

Here’s how it currently works:

For each day in the time period, the user enters their Time In/Time Out (at least the first set) and Time In/Time Out (second set). And the user enters the total hours manually.

Time In/Time Out 1 and 2 are date fields (HHMMSS 24 hour (military time if that matters)… so 13:00:00 is 1 p.m.)

What I need to do is have the first in/out calculate and the 2nd in/out calculate and then add those together for Total Hours for the day. 

I’m assuming I’m going to need to add a couple of calculated columns to do the calculations.  Need to to do this without code behind (not a developer and don’t have access/funds to hire one).  If I can’t get this to work, I may look at implementing an Excel version.  

?width=750

(Visited 263 times, 1 visits today)
Add a Comment