Adding time values

[B.Kellough]

I have a spreadsheet that has time values in column a in this format 12:01:49 AM, I want to add another column and be able to add "5" hours of time to each cell in the new column.

So if "A1" has "12:01:49 AM" in it then "B1" would display "5:01:49 AM"

and "A2" has "1:14:25 AM" in it then "B2" would display "6:14:25 AM"

and so on.

 

[p45cal]

=A1+5/24
untested.

 

[B.Kellough]

Tried it and that just gives me

<TABLE style="WIDTH: 67pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=89 border=0><COLGROUP><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: white 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #b8cce4; BORDER-LEFT: white 0.5pt solid; WIDTH: 67pt; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=middle width=89 height=17>#VALUE!

</TD></TR></TBODY></TABLE>

Might be a formatting issue?

 

[aitkensam]

Your dates are probably in some weird text format. Can try =VALUE(A1)+(5/24)

 

[B.Kellough]

Same result as before,

<TABLE style="WIDTH: 67pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=89 border=0><COLGROUP><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: white 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #b8cce4; BORDER-LEFT: white 0.5pt solid; WIDTH: 67pt; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=middle width=89 height=17>#VALUE!

</TD></TR></TBODY></TABLE>

 

[bamblack]

=A1+TIME(5,0,0)

Give this a shot

 

[B.Kellough]

Same results as before
<TABLE style="WIDTH: 67pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=89 border=0><COLGROUP><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: white 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #b8cce4; BORDER-LEFT: white 0.5pt solid; WIDTH: 67pt; COLOR: black; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Verdana; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=middle width=89 height=17>#VALUE!

</TD></TR></TBODY></TABLE>

I'm trying to change the formatting to see if that will help.

 

[B.Kellough]

changed the formatting to "hh:mm:ss" and that worked, thanks to all.