In column A I have dates (eg 7/1/2007), in column B I have time (eg hours:min:seconds) and in Column C I have the data logged for that time/date.
Is there an easy way to combine columns A and B?
In column A I have dates (eg 7/1/2007), in column B I have time (eg hours:min:seconds) and in Column C I have the data logged for that time/date.
Is there an easy way to combine columns A and B?
You could just sum the time and date in another column, e.g.
=A2+B2
format result cell as date/time
Audere est facere
Thank you! I had no idea that would work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks