Senior Member+
Excel file mey Auto time adjust karna
Assalamalykum ,
EEk choti shi help chayee,, Eek Excel sheet banani hay jis key First column mey (column A) mey time ka formula lagana hay key, jab bhi colmn B aur C mey data entry karey,, to automaticly Column A mey us data ki entry ka time ajayee..
For example.
No. ------------------------ A -----------B-------------C
1. -----------------------7:35 am ----- 280 ---------- 135
2. -----------------------8:42 am ----- 195 ---------- 326
Shukriya
Senior Member+
vry easy bhai..Habib said:
Function:
=now()
Advance Member
right Scimo .....thx for helping
Senior Member+
Shukriya Scimo ,, lykin yeh formula to mey pehley hi apply kar chuka hoon, is sey,, current time ata hay, aur jab bhi new data enter karey to ooper key sary data entry ka time bhi current ho jata hay,, jaysey key,,
2:30 am per jo data enter kiya tha, us key bad jo entry 3:00 am per hoti, to woh sara ka sara column bhi update ho ka,, sara time 3:00 am ho jata hay.
aur mera masla yeh hay key, har entry ka real time save karna chata hoon, jasa key foxpro wagera mey ho jata hay
shukriya
Senior Member+
so kind for information.............app is file ko save karay. aur phir usi file say open karay jo save hoga wo change nahi hoga...
app har cell main yah formula fit karay.....
=now()
=now()
=now()
Posting Permissions
Bookmarks