late

Hi There, I'm have some problems with data validation. What im trying to do is stop people over planning a line past the planned finish time. In column g you put in an amount that generates a finished time in column k I've tried to put the following validation in column g so that it stops...

Hi All, I have a spreadsheet that populates the employees time and attendance. I am trying to create a new tab that will only pull the data for lateness's from the main tab. <tbody> Area Badge Payroll No. Name Basic x.1.25 x1.5 x2 O/T Total Late Holiday Sickness Bank Holiday 04 Unpaid Holiday...

Hi, good day! I'd like to seek some help regarding how to make different formulas for the Daily Time Record of an employee. Situation: An employee logs in and logs out twice a day. Working schedule is 8:30 AM-12:00 PM then 1: PM to 5:30 PM with one hour lunch break. Now, my teacher wants us to...

Many years ago this forum helped me develop a macro / VBA that would run through a list and print the selected data into a form. I am trying to adapt this code to a new purpose and realizing I have forgot ALOT. This will be a long post but I hope it serves to provide all the data needed to...

Hi i have 2 dates and using the below formula due to different months this is not calculating correctly <tbody> 30/11/2018 21:10 03/12/2018 08:00 Late </tbody> =IF(I3< l3,"ok","late") <l3,"ok","late") <l3,"ok","late")[code]<l3,"ok","late")[ Can Anyone Help...

I am tracking our shipping departments shipments and have a basic table with 5 columns of data and am trying to automate the data collection from the report generated by our system. <tbody> Date Total Orders Total Late % Late % On-time 1-Jan-2019 9 1 11.11% 88.89% 2-Jan-2019 11 0 0.00%...

Need Help with the following Dates. i have a a file but cannot attach i have copied the table below hope. <colgroup><col><col span="2"><col><col><col span="3"><col span="2"></colgroup><tbody> A B C D E F G H I J 1 Allocation time last picked time time and date needs to be ready picked...

Hi All, I am trying to make a basic attendance for our school and would like to ask on how do I go about this; If I am to put "L" in a cell (which means Late), it will count or display it as 1 (meaning the student has incurred 1 Late). And if I am to put "LL" (meaning the student incurred two...

Hi, I have a large workbook tracking the attendance of various employees. I need to count how many people have certain events, ie how many people were late in a month or how many people are ill. I am getting an error whenever I use the following type of countifs, it has something to do with...

Hello, Here is a link to an image of the spreadsheet: https://agrissy92.files.wordpress.com/2018/09/excel.png. I tried this formula, =IFERROR([@[Amount]]-[@[Total Paid]]+[@[Late Fee]], "") but it did not work at all. I also tried this formula, =IF(F8>0,F8-I8,"") it works but it would show...

Should be easy. Column "A" has a DUE DATE. Based on the date as of TODAY(). Is it late or not? I can deal with simple true or false. It's just not working.

Looking for assistance in calculating how many hours late. <tbody> A B C IN OUT LATE 8:16 AM 5:00 AM L1 </tbody> In C, I would like the remarks L1 if late between 8:16 AM to 9:00AM, L2 if 9:01 AM to 10:00AM, L3 if 10:01 AM to 11AM and so on. I would like any help so each time I will...

I am drawing a blank...I want to take TODAY() date and compare it to a DUE Date and see if it is over due or not. I know this formula is probably simple. Example todays date is 10 May 2018: Book "A" is due 30 May 2018 = FALSE Book "B" is due 03 MAY 2018 = TRUE Book "C" is due 28 FEB 2017 =...

Hi, I need to merge the following two statements and I'm not sure how to merge them for them to work? =IF(E288="","Incomplete",IF(OR(E288<D288,E288=D288),"Completed",IF(E288>D288,"Cmp Late"))) =IF(C288>E288,"Early","Cmp or late") any if statement genius?

Hi All, I'm looking to adjust a query to display days along the top and month down the left column, is this possible please? Tables: Table1 = Months (January-December) & ref (numbers 1-12) Table2 = DayNum (day numbers 1-31) Table3 = Data: Date, code I'd like any code to show the output table...

Hi all! i know this is a bit hard and far fetch. But i was wondering if there is a way to implement this algorithm into vba to pick a job for process 1. enumerate jobs such that d1 ≤ . . . ≤ dn; 2. S1 := ∅; t := 0; 3. FOR j:=1 TO n DO 4. S1 := S1 ∪ {j}; t := t + pj; 5. IF t > dj THEN 6. Find...

<tbody> Part Number & Line Number SAHLATE 025403 1 -4 025403 1 -3 025403 1 -1 025403 2 0 025403 2 -4 025403 2 1 025403 3 1 025403 3 2 025403 3 0 </tbody> Hi there I need some help please, My first column contains a part numbers (3 sets). The second...

I'm trying to build a formula (in column G) that basically says, "If the worksheet that is named with the value of C2 on this worksheet has "Late" in the 2nd to Last Row, return Late. Otherwise, return the value of the Last Row." My challenges are: The sheets that I'd be searching on are...

Dear All, I am troubling with excel macro again. There is staff attendance workbook in which 12 monthly sheets (one sheet represent one month) take records of all staff attendance time. If they are late on a date, then "pl" is put in that date of column. At the end of the columns, BN Column...

Hi Guys getting there but still can't move the formula's across to the xpo departure times, plus "red circle and cross" is only for 15 minutes over the departure time. amber is the time in between the minutes 15, and the green tick is for on time and less time than departure time. As you can...