Hello all



Maybe this is a noob question but here I go. I'm a software developer and ironically this is like my third time ever using MS Excel. I'm using 2007 version.

The question is as follow:

I downloaded data from a software that show me the time and date which some images here in my job are processed. Here's is a screenshot of the data:



As you can see there, I have a column named "StartedTime" and the other one next to that one is named "FinishedTime". I have one of them showing me the time while the other is showing me the date. I can format this cell for them to show the time or the date. Is there ANY way to format them in order to see both, the time AND the date in the same space? If I put my cursor in a single row of one of the colum, it show me both, the time AND the date as you can see in the following example:



How I can format this columns so by default, all of it's rows show me BOTH the time, AND the date??? Thank you in advance!!!

I'm using 2003 but should be the same --- Format Cells / Custom /
m/d/yyy h:mm AM/PM

Do you require to combine the date & time int 1 cell! If so: =H1+I1 copy down & format the cells as you require. IE: dd/mm/yyyy hh:mm AM/PM depending on your regional settings.

You are a life savor. Thank you so much! Thank you both!