Combine columns of data into time

[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

 

[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)

 

[Bob Phillips]

Peo,

For my edification, why did you suggest

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

rather than

=TIME(A2,B2,C2)

Bob

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

 

[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

Peo,

For my edification, why did you suggest

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

rather than

=TIME(A2,B2,C2)

Bob

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

 

[Bob Phillips]

--

HTH

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

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

Peo,

For my edification, why did you suggest

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

rather than

=TIME(A2,B2,C2)

Bob

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

 

[Bob Phillips]

Aah, now it makes sense.

Thanks for that enlightenment Peo.

Bob

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

Peo,

For my edification, why did you suggest

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

rather than

=TIME(A2,B2,C2)

Bob

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