Hello there, I'm new here and I was wondering how can I make an attendance sheet that shows when a student missed that day and on which dates that student was picked up before a estimated hour.
Hello there, I'm new here and I was wondering how can I make an attendance sheet that shows when a student missed that day and on which dates that student was picked up before a estimated hour.
how are you going to layout the sheet
you could use conditional formatting to highlight missed days and times
but that depends on how you intend to complete the sheet
if you had names down the column in each row and dates across the columns so in Row1
then you have a matrix - that can then be completed
As you also want times - then you would need to think about how they would be entered
is this the same time every day for a student or does it vary -
a little more info is needed really
perhaps try setting up a draft spreadsheet and attaching here
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
So here's the sheet how can I sum the times they missed school or didn't attended, when I typed N/A in those cells instead of a number.
That's the only thing I'm missing
I used the formatting tool to know how many times the girl was picked up before 4:30 PM and it worked.
Also I can't seem to attach the xlsx file in here for some reason.
use COUNTIF()
to sum up cells with a criteria
=COUNTIF( range of cells , "N/A" )
that will count all the cells that have N/A in
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
here it is
you can use countif()
assuming the checked out column will always have N/A
=COUNTIF(D:D,"N/A")
and the time for 16:30
=COUNTIF(D:D,">"&TIME(16,30,0))
see attached
Thanks It worked with the COUNTIF(range,"#N/A")
Is there a way I can upvote you or anything in here?
you can click on add reputation - thats all
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks