Waxaad si fudud u bedeli kartaa qaabka unug kasta xaashida shaqada ee Excel si aad u ogeysiiso codsiga nooca xogta la filayo. Laba qaab oo inta badan la isticmaalo waa taariikhda iyo wakhtiga.

Dhab ahaantii, gelinta taariikhda iyo wakhtiga Excel waa wax caadi ah, Microsoft waxay ku dhistay dhowr habab iyo shaqooyin si ay kaaga caawiyaan inaad ku darto xogta noocaan ah xaashida shaqadaada. Baro sida loogu daro taariikhda go'an iyo kuwa firfircoon labadaba iyo stamps si degdeg ah Excel .

Taariikhaha go'an iyo Waqtiga

Dad badan ayaa inta badan isticmaala Excel si ay ula socdaan agabka, qaansheegyada, dakhliga/kharashyada, iyo adeegsiyada kale duwan ee u baahan in si sugan loo diiwaangeliyo taariikhda iyo wakhtiga. Excel waxay leedahay qaar lagu dhisay wadooyin gaaban si ay ugu darto taariikhda iyo waqtiga hadda la joogo hawl degdeg ah.

Ka soo qaad^(Suppose) inaad haysatid xaashi cusub oo Excel ah oo furan oo aad rabto inaad bilowdo inaad ku darto xoogaa xog ah oo ku xidhan taariikhda maanta. Halkii aad ku qori lahayd, waxaad isticmaali kartaa hababkan gaaban. Si aad taariikhda hadda ugu darto unug, ku billow adigoo gujinaya unugga meesha aad rabto inaad taariikhda ku jirto si ay ugu jirto xaashida shaqada. Hoos u dhig furaha Ctrl oo ku dhufo ; (semicolon) furaha. Taasi waxay gelin doontaa taariikhda hadda jirta unug kasta oo firfircoon.

Si aad u geliso wakhtiga hadda, dhagsii unugga meesha aad rabto inaad ku kaydiso wakhtiga hadda. Qabo labada furayaasha Ctrl iyo Shift oo taabo ; (semicolon) furaha. Taasi waxay gelin doontaa wakhtiga hadda la joogo unugga.

Si aad u geliso taariikhda hadda iyo wakhtiga xaadirka ah labadaba isla unug, dhagsii unugga meesha aad rabto in taariikhda iyo wakhtiga ay ku jiraan xaashidaada shaqo. Qabo furaha Ctrl oo taabo ; furaha. Hadda, ku dhufo barta bannaan^{(space bar)} oo hay Ctrl iyo Shift furayaasha oo taabo ; furaha.

Ogsoonow in kastoo aad gelisay labadaba taariikhda iyo wakhtiga hadda jira unugyada, qiimayaashani weligood isma beddelayaan. Si aad u geliso taariikhaha firfircoon, waxaad u baahan tahay inaad adeegsato hawlaha gudaha ee Excel.

Taariikhda iyo wakhtiga firfircoon

^(Dynamic)Taariikhaha iyo waqtiyada firfircooni waxay u muuqan karaan inay taagan yihiin, laakiin dhab ahaantii waxay beddelaan taariikhda iyo wakhtiga hadda jira mar kasta oo faylka Excel la furo ama marka qaababka xaashida shaqada la xisaabiyo. Waxaa jira dhowr sababood oo aad ugu baahan karto firfircooni halkii aad ka ahaan lahayd taariikh ama waqti taagan.

Marka hore, haddii mid ka mid ah hababkaaga ay ku xiran tahay taariikhda ama wakhtiga hadda, isticmaalka firfircooni wuxuu kaa caawinayaa inaad iska ilaaliso inaad geliso macluumaadka la cusboonaysiiyay mar kasta oo aad furto faylka ama aad sameyso xisaabin cusub. Midda labaad^(Second) , adiga oo taarikh ama waqti firfircoon ag dhiga unug kale oo xisaab ka kooban, waxaad isla markiiba ogaan kartaa markii ugu dambeysay ee xisaabinta la sameeyay.

Si aad u geliso shaambada taariikhda firfircoon ee Excel , geli qaacidada soo socota unug kasta:

=TODAY()

Excel wuxuu isla markiiba gelin doonaa taariikhda hadda jirta unuggaas. Mar kasta oo aad furto buugga shaqada ama aad samayso xisaab cusub, Excel waxa ay u cusboonaysiin doontaa unugga taariikhda hadda la joogo.

Si aad u geliso shaambada taariikhda iyo wakhtiga firfircoon ee Excel , geli qaacidada soo socota unug kasta:

=NOW()

Excel wuxuu isla markiiba gelin doonaa taariikhda iyo wakhtiga hadda la joogo unuggaas. Mar kasta oo aad furto buugga shaqada ama xisaabin cusub ayaa lagu sameeyaa xaashida shaqada, Excel waxay u cusbooneysiin doontaa unugga taariikhda iyo waqtiga hadda.

Nasiib darro, ma jirto wax shaqo ah oo lagu geliyo kaliya shaambada wakhtiga firfircoon ee Excel . Si kastaba ha ahaatee, waxaad bedeli kartaa habaynta unugga si aad u muujiso waxqabadka hadda wakhtiga oo keliya. ^(NOW)Guji tabka Guriga ee ku yaal ^(Home)Ribbon oo hel qaybta ku calaamadsan Lambarka^(Number) . Guji liiska hoos-u-hoosaadka^{(drop-down menu)} oo ka dooro Waqtiga^(Time) xulashada menu-ka.

Iyada oo ku xidhan baahidaada, waxaad geli kartaa mid taagan ama taariik ah iyo waqti stamps gudaha Excel si ay kaaga caawiyaan samaynta xisaabinta ama aad ula socoto wakhtiga ugu dambeeya ee xisaabinta la sameeyay. Hubi inaad dooratay midka saxda ah si aadan si badheedh ah u samayn xisaabin khaldan oo lagu dhisay Excel iyo qaacidooyinka gaarka ah. Ku raaxayso!

Quickly Add Date and Time Stamps to an Excel Worksheet

You can easily change the format of any cell in an Excel worksheet to let the application know what type of data to expect. Two often used formatѕ are the date and time.

In fact, inserting the date and time into Excel is so common, Microsoft built in a few shortcuts and functions to help you add these types of data into your worksheet. Learn how to add both fixed and dynamic date and time stamps quickly into Excel.

Fixed Dates and Time

Many people often use Excel to keep track of inventory, invoices, income/expenses, and a variety of other uses that require statically recording the date and time. Excel has some built in shortcuts to make adding the current date and time a quick chore.

Suppose you have a new Excel worksheet open and you want to start adding some data that is tied to today’s date. Rather than typing it in, you can use these shortcuts. To add the current date to a cell, begin by clicking on the cell where you want to date to be in your worksheet. Hold down the Ctrl key and hit the ; (semicolon) key. That will place the current date into any active cell.

To insert the current time, click on the cell where you want to store the current time. Hold down both the Ctrl and Shift keys and press the ; (semicolon) key. That will place the current time into the cell.

To insert both the current date and the current time into the same cell, click on the cell where you want the date and time to be in your worksheet. Hold down the Ctrl key and press the ; key. Now, hit the space bar and hold down the Ctrl and Shift keys and press the ; key.

Note that although you inserted both the current date and time into the cells, these values will never change. To insert dynamic dates, you need to use Excel’s built-in functions.

Dynamic Date and Time

Dynamic dates and times may appear to be static, but actually change to the current date and time whenever the Excel file is either opened or when formulas in the worksheet are calculated. There are several reasons why you may need a dynamic rather than a static date or time.

First, if any of your formulas are dependent on the current date or time, using a dynamic function helps you avoid having to insert updated information every time you open the file or run a new calculation. Second, by placing a dynamic date or time next to another cell that contains a calculation, you can instantly know the last time the calculation was made.

To insert a dynamic date stamp into Excel, enter the following formula into any cell:

=TODAY()

Excel will instantly put the current date into that cell. Every time you open the workbook or make a new calculation, Excel will update the cell to the current date.

To insert a dynamic date and time stamp into Excel, enter the following formula into any cell:

=NOW()

Excel will instantly put the current date and time into that cell. Every time you open the workbook or a new calculation is made in the worksheet, Excel will update the cell with the current date and time.

Unfortunately, there is no function to insert only a dynamic time stamp into Excel. However, you can change the formatting of the cell to make the NOW function display only the time. Click the Home tab on the Ribbon and locate the section labeled Number. Click on the drop-down menu and select Time from the menu options.

Depending on your needs, you can insert either static or dynamic date and time stamps into Excel to assist you in making calculations or to keep track of the last time a calculation was made. Make sure you choose the right one so you don’t inadvertently make incorrect calculations with Excel’s built in and custom formulas. Enjoy!

Related posts

• Sida loo beddelo qaabka taariikhda iyo wakhtiga ee Windows

• Geli xaashida shaqada ee Excel Word Doc

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida Loo Geliyo CSV ama TSV Xaashida Shaqada ee Excel

• Sida loo beddelo wakhtiga iyo taariikhda Windows

• Gacanta Kudar Xiriiriye Buugga Ciwaanka Boostada ee Windows Live

• Demi Koontaroolada Koontada Isticmaalaha (UAC) ee Codsi Gaar ah

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

• Si degdeg ah ugu beddelo Xaashiyaha shaqada ee Excel

• Sida loo beddelo Serial Number taariikhda Excel

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel

• 8 ka mid ah Fikradaha Farsamada ugu Fiican ee lagula tacaali karo Go'doominta

• Sida Loo Jadwaleeyo iimaylka Si Aad U Baxdo Wakhti Go'an

• Ku rakibida GIMP Plugins: Habka-Hagaha

• Oggolow ama ka ilaali isticmaalayaasha inay beddelaan taariikhda iyo wakhtiga Windows 10

• Deji taariikhda uu dhacayo faylalka Google Drive ee la wadaago

• Sida loo xisaabiyo leexashada caadiga ah ee Excel

• Sida Loo Qaado Screenshots on Nintendo Switch

• Sida Taariikhda loogu kala saaro Excel