Formula to add time

[gamezcua22]

Does anyone know of a formula to add time in access 07? Any help is apreciated.

 

[boblarson]

What kind of time?

In a query:

NewAliasNameHere:DateAdd("n", 24, [FieldNameHere])

In VBA

Me.SomeControlNameHere = DateAdd("n", 24, Me.TextBoxNameHere)

n - minutes
s - seconds
h - hours

 

[gamezcua22]

This works for a date but what im looking for is this:

8:00:24 + 1:24:00 = 8:24:24

is there a way to get this with access?

 

[boblarson]

This works for a date but what im looking for is this:

8:00:24 + 1:24:00 = 8:24:24

is there a way to get this with access?

You can use
#8:00:24# + #1:24:00#

(oh and your example is wrong - it should be 9:24:24)

 

[boblarson]

This works for a date

It also works for Times as long as you're adding specific items (hours or minutes or seconds) and not adding two times together. For that you use what I posted just before this post.

 

[gamezcua22]

lol!! yea i should have caught that..

So can i use this:

Sum(#[FeildName]#) ?

 

[boblarson]

lol!! yea i should have caught that..

So can i use this:

Sum(#[FeildName]#) ?

You probably have to use

Sum("#" & [FieldName] & "#")

 

[boblarson]

I take that back - Where are you trying to do this? In a report, in a query?

In a query it should give you a decimal value which you can then format back to a time.

In a report you shouldn't need the octothorpes (#) if a control source is just

=Sum([FieldName])

and the control that is bound to that field is DIFFERENT (txtFieldName) and not the same. Otherwise it will give you the #NAME error.

 

[gamezcua22]

I have a form that shows how long it will take a machine to finish an order. like this

machine A 4:00:00
machine b 5:00:00
machine c 2:00:22
machine d 3:00:15

Total: 14:00:37

i am trying to sum the time feild to get a grand total for time.
if i try the sum() it brings back a decimal, i tried the divide by 24 but the grand total time is wrong it should be coming back with like 92+ hours of work.

 

[boblarson]

You should be able to use:

=Format(Sum([FieldName]), "hh:nn:ss")