CODEWITHSUNDEEP
excelformatting
Mik
Mik

Reputation: 23

aggregate hours minutes seconds text columns to time - Excel

I have 3 columns formatted as text: hours, minutes, seconds I need to consolidate them in a time format e.g.

1  34  56 -> I need a cell with 1:34:56

23 02  11 -> 23:02:11

Is this possible without macro/code? I had issues with escaping the colon

Upvotes: 2

Views: 1287

Answers (1)

OldUgly
OldUgly

Reputation: 2119

Did you look up the "TIME" built in function? See the screen shot ...

enter image description here

Upvotes: 2

Related Questions