Friends,
I have a data in which in one column date is given and in other column time is given. I need to combine both date & time in a single column in format DD:MM:YY H:MM
Kindly send me solution to this problem.
Menu
Combination of date & time
Replies (2)
just simple
if a cell contains date & b cell contains time then next cell put the formula a+b and change the format of the cell as "dd/mm/yyyy hh:ss AM/PM"
if cell 'A1' contains date & cell 'B1' contains time then put the formula =concatenate(A1," ",B1) in any blank cell(i.e.equal to sign then type concatenate then opening bracket then A1 then comma then one space in double inverted comma or double quote then again comma and then B1 then complete the bracket)
Recent Topic
- Client consent under DPDPA: Is client sharing PAN,
- TDS MISMATCH
- Rebate on other income even if LTCG is above my 12
- Need CA to certify shareholding pattern.
- Ltcg savings
- Please share the roc and income tax compliance fo
- Proprietor have 2 business. One is registered unde
- ITR-4 – Gross Receipts or Turnover for Secti
- Unrelated entries in AIS and Form 26as
- Payment to foreign national
Related Topics
CAclubindia
