Hi,
I have data in excel, in which column A contains date in mm/dd/yy format and column B contains time in hh:mm format. I want to combine date and time in column C. but I am not able to do it.
Anyone can help me to solve this puzzle.
Thanks
Hi,
I have data in excel, in which column A contains date in mm/dd/yy format and column B contains time in hh:mm format. I want to combine date and time in column C. but I am not able to do it.
Anyone can help me to solve this puzzle.
Thanks
Hi,
In column C, =A1+B1
Format the cell as dd/mm/yy hh:mm
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks