time attendance

Hi There We have a Fingerprint reader for our staff Time & Attendance. Attached the standard report from the device - untouched https://www.excelforum.com/attachment.php?attachmentid=607220&stc=1&d=1548060569 Now in this report, it give a daily breakdown of the Employee Check IN, Breaks and...

Subtract dates and times for overtime ...and also consider weekends and holidays PLEASE PLEASE HELP I need help with a formula to deduct ie dates and times to calculate regular time and overtime and multiply the regular time with the basic salary of R18.75 (Rand)....and Saturdays with...

Hi I am trying to create an overtime sheet for my Hospital's salaries department and I am stuck! They need to have an out put of the exact hours worked (eg 09:00-17:00) for each day. Some people my work onsite in the hospital on several occasions per day so the exact hours for these need to be...

Hello, I would like Excel to insert a time in and a time out into the time in and out columns. When someone arrives we change the 0 to a 1 next to their name and then enter in the time manually to the time in column. When they leave we change 1 back to a 0 and then enter in the time manually to...

I am trying to set up a workbook to count the number of each job class that is working at a certain time, I am using this formula: =COUNTIFS(Data!$AA:$AA,Daily!$A3,Data!$J:$J,Daily!$C3,Data!$S:$S,"<="&Daily!E$1,Data!$V:$V,">="&Daily!E$2) Data!$AA:$AA= jobcode Daily!$a3= Jobcode I want to count...

Happy New Year to everybody, I am trying to make a time-sheet format from a row attendance data. Row data will look like as below: <tbody> ID # Date Time Type 100 1/1/2017 07:00 AM IN 100 1/1/2017 05:00 PM Out 100 2/1/2017 08:00 AM IN 100 2/1/2017 01:00 PM Out 100 3/1/2017 10:00 PM In...

I'm trying to make a cell automatically return what the current shift is, for example if it is between 7:00 am and 3:00 pm return 1st shift, between 3:00 pm and 11:00 pm 2nd shift and 11:00 pm to 7:00 am 3rd shift. All I want to see in the cell is 1st, 2nd or 3rd shift when it is within their...

I have rows of time values with some of them having specific text in them.. example a below. <tbody> 8:00 9:41 11:48 (Out) 12:52 (In) 13:01 13:01 13:02 13:08 0:00 0:00 </tbody> Can you suggest a formula to get the below values. The specific text is (out) and (in)...

I have to calculate the idle Hrs of a working employee. Three shifts are there. Morning 7AM to 3PM Evening 3PM to 11PM Night 11 PM to 7AM. Also if overtime then shift pattern is Morning 7AM to 7PM Evening 11AM to 11PM Night 7PM to 7AM. So the in time for an employee will be based on the...

Background: I am a new intern at a custom interior design company and I have been hired to streamline and simplify the process that they go through with tracking inventory and the time spent on different jobs so they can calculate their job costs accurately. I have spent days working on this...

I have agents with varying start and end times and I'm trying find a macro or formula to return the number of agents scheduled for the times listed. I have included a sample set of data and the values that I know the formula or macro should return. Any help would make a HUGE difference to me...

Hello, i have been struggling with this issue but cannot resolve it,hope someone could help me with this. I have access control wich has export to excel . In this exported table there are some fields like user name , time , IN (user goes in the office) , OUT (user goes out of the office) . I...