Also, if you cross over midnight, you have to take into account the differences in seconds with an additional calculation, adding a days worth of seconds if you have a negative result in your calculation. I use a 24 hour type entry - like time in: 2200 for 10 p.m.
BobC
| "Victor Leach"
<[EMAIL PROTECTED]>
Sent by: [email protected] 07/10/2005 10:46 PM
|
|
Hi Tom
Check your data type the returned value will be seconds and an integer. It must be timeout-timein for postive value
Victor
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of TOM HART
Sent: Monday, 11 July 2005 11:36 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Time calculations
I am making a table to keep track of employees time. I have timein and timeout and a calculated column of totaltime. When i enter times the calculated column remains null. This is probably something very simple, but any help would be appreciated
Tom Hart
