Combine columns of data into time

K

Kevin Howard

I have three columns of data, one each for hours, min,
seconds. How do I combine these three columns into one
time formated column?

Thanks,

Kevin
 
P

Peo Sjoblom

Assume the hours start in A2, minutes in B2 and seconds in C2, in a 4th
column use this formula and copy down, custom format [hh]:mm:ss

=A2/24+TIME(,B2,C2)
 
B

Bob Phillips

Peo,

For my edification, why did you suggest

=A2/24+TIME(,B2,C2)

rather than

=TIME(A2,B2,C2)

Bob


Peo Sjoblom said:
Assume the hours start in A2, minutes in B2 and seconds in C2, in a 4th
column use this formula and copy down, custom format [hh]:mm:ss

=A2/24+TIME(,B2,C2)




--

Regards,

Peo Sjoblom


Kevin Howard said:
I have three columns of data, one each for hours, min,
seconds. How do I combine these three columns into one
time formated column?

Thanks,

Kevin
Click to expand...
Click to expand...
 
P

Peo Sjoblom

Hi Bob,

I believe time only handle hours up to 24, so if the OP happens to have
28 hours 28 minutes and 28 seconds it will return 4:28:28

--

Regards,

Peo Sjoblom


Bob Phillips said:
Peo,

For my edification, why did you suggest

=A2/24+TIME(,B2,C2)

rather than

=TIME(A2,B2,C2)

Bob


Peo Sjoblom said:
Assume the hours start in A2, minutes in B2 and seconds in C2, in a 4th
column use this formula and copy down, custom format [hh]:mm:ss

=A2/24+TIME(,B2,C2)




--

Regards,

Peo Sjoblom


Kevin Howard said:
I have three columns of data, one each for hours, min,
seconds. How do I combine these three columns into one
time formated column?

Thanks,

Kevin
Click to expand...
Click to expand...
Click to expand...
 
B

Bob Phillips

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Peo Sjoblom said:
Hi Bob,

I believe time only handle hours up to 24, so if the OP happens to have
28 hours 28 minutes and 28 seconds it will return 4:28:28

--

Regards,

Peo Sjoblom


Bob Phillips said:
Peo,

For my edification, why did you suggest

=A2/24+TIME(,B2,C2)

rather than

=TIME(A2,B2,C2)

Bob


Peo Sjoblom said:
Assume the hours start in A2, minutes in B2 and seconds in C2, in a 4th
column use this formula and copy down, custom format [hh]:mm:ss

=A2/24+TIME(,B2,C2)




--

Regards,

Peo Sjoblom


I have three columns of data, one each for hours, min,
seconds. How do I combine these three columns into one
time formated column?

Thanks,

Kevin
Click to expand...
Click to expand...
Click to expand...
 
B

Bob Phillips

Aah, now it makes sense.

Thanks for that enlightenment Peo.

Bob

Peo Sjoblom said:
Hi Bob,

I believe time only handle hours up to 24, so if the OP happens to have
28 hours 28 minutes and 28 seconds it will return 4:28:28

--

Regards,

Peo Sjoblom


Bob Phillips said:
Peo,

For my edification, why did you suggest

=A2/24+TIME(,B2,C2)

rather than

=TIME(A2,B2,C2)

Bob


Peo Sjoblom said:
Assume the hours start in A2, minutes in B2 and seconds in C2, in a 4th
column use this formula and copy down, custom format [hh]:mm:ss

=A2/24+TIME(,B2,C2)




--

Regards,

Peo Sjoblom


I have three columns of data, one each for hours, min,
seconds. How do I combine these three columns into one
time formated column?

Thanks,

Kevin
Click to expand...
Click to expand...
Click to expand...
 
Top