Adding time trouble

[NightWalker]

I am trying to add 8.5 hour to a time in a txtbox that is bound to a form.


why does this code not work?

txtShiftEnd = DateAdd("h", 8, [TimeIN]) & DateAdd("n", 30, [TimeIN])

i get a really crazy answer with the second one like it is putting 2 answers in the same text box. so i tried this to add the two together. and it didnt work.

txtShiftEnd = DateAdd(sum("h", 8, [TimeIN]) & ("n", 30, [TimeIN]))

I figured it out by using this code but i am wondering why it didnt allow the first one to work

txtShiftEnd = DateAdd("n", 510, [TimeIN])

Thank you for your instruction and clarification


Walker

[ranman256]

it the time in the txtbox is in hours, then:
txtBox + 8

it you want the TIMEOUT :
txtTimeOut = DateAdd("h",8.5,TIMEIN)

[NightWalker]

txtTimeOut = DateAdd("h",8.5,TIMEIN)

I tried that and it only gave me an even number. the time in the TimeIN txtbox was 8:00 and the answer it gave me was 16:00 even though i had 8.5 to add to it

[ranman256]

then your field is formatted wrong (integer or long) , you need to format is as single to see decimals.

[NightWalker]

<------Palms forehead and saya "oh yeah......DUH!"

Thanks ranman