adding time

[jawbone]

hello everyone, i have a problem that is probably simple to you to figure out. im using access 07 and novice as hell. I recently created a database form so that i can calculate my non-revenue miles for this transportation service im employed, unfortuntaly those particular hour i dont get paid for. Anyway i created a simple time sheet using military time. example. clock in time 13:00 til 15:00 which is 2 hours worked, but how can i get access to do that. i created an query. the expression is Totalhours:[timeend]-[timestart]= still nothing. can someone help me pls.

[patjones]

Is the total hours calculation being done in another text box on the same form? Also, where exactly are you writing out the expression to do the subtraction? Generally, calculated controls need to have the expression put in the Control Source setting in the property sheet.

Pat

[ADezii]

TotalHours:DateDiff("h",[TimeStart],[TimeEnd])

[jawbone]

can i email you guys my dbf so you can see my problem, sorry im so dumbfounded.

[ADezii]

@jawbone:
Attach you Database to another Post.

[NeoPa]

How are [TimeEnd] and [TimeStart] defined? If they are both DateTime variables then what you have should already work. Why do you think it isn't? What are you seeing? We cannot help you unless you express the question clearly and keep us fully informed (as we can't see what you're doing - we rely on your question and explanation).

[jawbone]

thanks NeoPa i change my datatype to DateTime instead of text and it calculated fine. Thanks for your time everyone.

[NeoPa]

That would certainly explain it.

You may want to select a post here as Best Answer before you go.