How do you add time?

[Fiona H]

Is it possible to add time in a query? I have to add the number of hours overtime worked and I'm getting a data type mismatch error message.

The time field is in hours, so I am wondering if I need to covert it to a decimal to add it up?

Please could someone point me in the right direction? Thanks

 

[John Big Booty]

See the DateAdd() function.

 

[Fiona H]

Thanks for getting back to me do quickly John...

I've just doing a lap of honour around the office for having figured out how to convert time into a decimal so that I can add it up!

Once it's a decimal I think iw ill be able to manupulate it ok.

Thanks again

 

[John Big Booty]

Good work

 

[namliam]

No need to convert time to a decimal, it is a decimal...

Any date time you can add to no problems...
Time() + 1/24 adds 1 hour
Time() + 1/60/24 adds 1 minute
Time() + 1/60/60/24 adds 1 second
Date() + 1 adds 1 day
etc...