Time Sheet

[Justin]

I am trying to make a timesheet. I have a a textbox for time in and time out.
It will always be the same day because if it goes over midnight we enter a
new entry for the next day due to the way billing is calculated. This is what
i have:

DateDiff("h",[FriTimeIn1],[FriTimeOut1])

If i use 0700 and 1500 it returns 19200. what am i doing wrong!

 

[KARL DEWEY]

1500 - 700 = 800 Access sees this as days.
DateDiff("h", take the difference in days and multiples by 24 to get
19200 hours.

 

[Justin]

Ok. How can I record a result of an expression?

1500 - 700 = 800 Access sees this as days.
DateDiff("h", take the difference in days and multiples by 24 to get
19200 hours.

--
KARL DEWEY
Build a little - Test a little

I am trying to make a timesheet. I have a a textbox for time in and time out.
It will always be the same day because if it goes over midnight we enter a
new entry for the next day due to the way billing is calculated. This is what
i have:

DateDiff("h",[FriTimeIn1],[FriTimeOut1])

If i use 0700 and 1500 it returns 19200. what am i doing wrong!

 

[KARL DEWEY]

Use a DateTime field to record the time in and time out. Then Access can
use the DateDiff as the function is entended.
--
KARL DEWEY
Build a little - Test a little

Ok. How can I record a result of an expression?

1500 - 700 = 800 Access sees this as days.
DateDiff("h", take the difference in days and multiples by 24 to get
19200 hours.

--
KARL DEWEY
Build a little - Test a little

I am trying to make a timesheet. I have a a textbox for time in and time out.
It will always be the same day because if it goes over midnight we enter a
new entry for the next day due to the way billing is calculated. This is what
i have:

DateDiff("h",[FriTimeIn1],[FriTimeOut1])

If i use 0700 and 1500 it returns 19200. what am i doing wrong!

 

[Justin]

I understand that. The expression entered into the control source. I need
that recorded because I take A report of the weekly hours and take a total.

Use a DateTime field to record the time in and time out. Then Access can
use the DateDiff as the function is entended.
--
KARL DEWEY
Build a little - Test a little

Ok. How can I record a result of an expression?

1500 - 700 = 800 Access sees this as days.
DateDiff("h", take the difference in days and multiples by 24 to get
19200 hours.

--
KARL DEWEY
Build a little - Test a little


:

I am trying to make a timesheet. I have a a textbox for time in and time out.
It will always be the same day because if it goes over midnight we enter a
new entry for the next day due to the way billing is calculated. This is what
i have:

DateDiff("h",[FriTimeIn1],[FriTimeOut1])

If i use 0700 and 1500 it returns 19200. what am i doing wrong!

 

[KARL DEWEY]

Use the DateTime fields in your table. Use the DateDiff function in the query.
--
KARL DEWEY
Build a little - Test a little

I understand that. The expression entered into the control source. I need
that recorded because I take A report of the weekly hours and take a total.

Use a DateTime field to record the time in and time out. Then Access can
use the DateDiff as the function is entended.
--
KARL DEWEY
Build a little - Test a little

Ok. How can I record a result of an expression?

:

1500 - 700 = 800 Access sees this as days.
DateDiff("h", take the difference in days and multiples by 24 to get
19200 hours.

--
KARL DEWEY
Build a little - Test a little


:

I am trying to make a timesheet. I have a a textbox for time in and time out.
It will always be the same day because if it goes over midnight we enter a
new entry for the next day due to the way billing is calculated. This is what
i have:

DateDiff("h",[FriTimeIn1],[FriTimeOut1])

If i use 0700 and 1500 it returns 19200. what am i doing wrong!