dire need of help

[thelostcircuit]

im wondering if there is a way to add time to the curent time for example

Now() = 2:00AM + 5hrs = 7:00AM

i have also seen a lot of postes about timers but im looking for a emediate solution

Thank you for any help that can be provided

 

[MStef]

Hello thelo!
Look at "DemoHourAddA97.mdb",
i think it can help you.

 

[Bat17]

The main thing to remember is that Date is stored as days and time as fractions of time.
so 5hrs is 5/24ths of a day
Now() = 2:00AM + 5hrs = 7:00AM
Now() = 2:00AM + 5/24day = 7:00AM
so your new time field will look something like:-

=Now() + ([HoursToAdd])/24

HTH

Peter

 

[neileg]

You should look at DateAdd()

Remember that Now() returns a date and time, not just a time. Even if you format the results to exclude the date, it's still there

 

[thelostcircuit]

than you all for you input

what im trying to do is make a database for a tumble metal finishing process

there are 5 mashines that run simultaneously there are a number of oporations witch change the cycle times

each tumbler can have 1 job/part number in it at a time

what im trying to do is once the part number, shop order #, # of peces, oporation and mashine # are filled in they press a load button and it will stamp the current time"timeloaded" the rincetime witch is diferent based on the oporation and the pull time witch is also changed by the oporation

the rince time and pull time are the ones that i need to add the time to the curent time

then when the time comes around the rinse putton needs to just stamps the curent time

next the pull button needs to stamp the time and move the record to a archive table so its not in a tumbler


i have attached what i have now i could still use a more skilled user to adopt me i need help