arshadmohamed
New Member
- Joined
- Jan 18, 2005
- Messages
- 18
Hiiiii
I have some data entered in a Excel like this..
Each time i open this work book i want the current system date datas to be appearing in some particular cell like in "H6, H7, H8 & H9"
issit possible to compare and check for current system dates?
If so how will i make the assigned time data's appear in some plc in the sheet?
Date Time-1 Time-2 Time-3
01-01-05 10:01 23:06 8:15
02-01-05 11:01 0:06 9:15
03-01-05 12:01 1:06 10:15
04-01-05 13:01 2:06 11:15
05-01-05 14:01 3:06 12:15
06-01-05 15:01 4:06 13:15
07-01-05 16:01 5:06 14:15
08-01-05 17:01 6:06 15:15
I have some data entered in a Excel like this..
Each time i open this work book i want the current system date datas to be appearing in some particular cell like in "H6, H7, H8 & H9"
issit possible to compare and check for current system dates?
If so how will i make the assigned time data's appear in some plc in the sheet?
Date Time-1 Time-2 Time-3
01-01-05 10:01 23:06 8:15
02-01-05 11:01 0:06 9:15
03-01-05 12:01 1:06 10:15
04-01-05 13:01 2:06 11:15
05-01-05 14:01 3:06 12:15
06-01-05 15:01 4:06 13:15
07-01-05 16:01 5:06 14:15
08-01-05 17:01 6:06 15:15