I have two columns A being the date B being time (24hr). Is there any way of combining the two columns together.
I am trying to calculate the elapsed time.
Previously I have physically typed the time into the date cell, this takes a long time as I have up to 1000 entries.
I am trying to calculate the elapsed time.
Previously I have physically typed the time into the date cell, this takes a long time as I have up to 1000 entries.