Hello.
I need to know the formula I need to calculate how many days it will take a student to get from the given absenteeism rate down to 10.
School is 6.5 hours a day
The numbers are in general format
I thought about putting some other formula (school day formula) that adjusts automatically...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.