Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 11-02-2018, 04:43 AM
p45cal's Avatar
p45cal p45cal is offline Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Windows 10 Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by Marcia View Post
When and if a student skips classes (am) and is late (pm) on the same day, the late triangle should be placed on the left, the cutting classes shape on the right regardless of the time of misdemeanor, so only the codes LTIC, LLEC, LC should be used. The teacher will have a note somewhere in the form on additional info like the above cases. The same holds true with am cutting classes, pm absent, where the X is typed on the left, the cutting class shape placed on the right.

I'd be a bit wary of this plan. You have a system where the upper left half of a cell is always the morning, and the lower right always the afternoon. Now you have to make an exception if there's a red triangle: you don't know if the lateness is in the morning or not, you don't know if the cutting classes is in the morning or not, the absenteeism could be morning or afternoon. I'd strongly recommend not doing this.
There are plenty of ways to indicate things in the cells while keeping the am/pm layout correct.
It looks as if cutting classes could be split am/pm, or perhaps you're happy for this to be represented without am/pm information? Either way there are plenty of ways you might represent this in a cell - it's down to your imagination.
For example, you might use one of these to show the student has been cuttting classes sometime on a day (no am/pm nformation):




Instead, you could keep am/pm information this way:


It's fairly obvious what's happening.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
New learner need help - convert tables in word format to ppt slides. sas Word VBA 5 09-21-2017 08:33 PM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Good morning/afternoon/evening based on time dwirony Word VBA 1 01-03-2017 01:01 PM
Need conditional formatting formula namedujour Excel 1 05-27-2016 08:58 AM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Conditional Formatting Formula teza2k06 Excel 1 08-22-2014 02:49 AM
Conditional Formula UICOMP Excel 1 05-18-2012 12:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft