Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon

FAQ

Thread Tools

Display Modes

10-29-2018, 09:22 AM

Marcia

Windows 7 32bit Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Remove the CT code, it should be CTI. The rest of the codes above are okay.

Thank you for the XL and LX codes, I haven't thought of those possibilities

I agree with your suggestions re spaces, go ahead with that.

As for the C code, there's no distinction whether am or pm.
No other codes (TIC, LEC, LETI, TILE) . I am sure I have covered all the conditions.

Last edited by Pecoflyer; 10-30-2018 at 04:23 AM. Reason: Removed quote

« Previous Thread | Next Thread »

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
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 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 05:26 PM.