know the timing in advance

M

mangesh

hi
i have an excell sheet and in that excell sheet in column a1 to a100
have put the timing of appointments. for example if have meeting at 1
o'clock i have put in column a1 "12" and this goes on upto a 100. No
i would like to know, before 15 minutes that is at 11.45 the excel
should warn me that your next meeting is at 12 o'clock. is it possibl
in excel, if yes please can you help me for the same
 
F

Frank Kabel

Hi
though this is generally possible using for example a conditional
format with a condition like
=MOD(NOW(),1)-(TIME(0,15,0)<=A1

I generally would recommend you don't use Excel for this. Use Outlook
or any other time scheduling program for this!
 
Top