> use seconds in an integer field...
> they are easier to work with....
>
> using epoch time (01/01/1970 00:00:00.000)
>
> you can use that as a base, and do dateDiff's and dateAdd's using (now())
> or a date in the future....to get seconds in between two events...
>
> if you need more code to look @ this to make sense of what im trying to
> explain
> let me know...
>
> tony

Just as a basic example, how would I start by allocating something 17 and a
half hours, then insert three entries into another table which total more
than 17 and a half hours (15.5, 5.75, and 6.5, which totals 27.75 on my
calculator) then calculate the overage?

I get the insert (kinda) for the original time (17 hours, 30 minutes, 0
seconds?) and I'm assuming the insert for the three "used times" would be
the same general insert, but it's the pulling out and calculating that's
kinda stumping me...I think...
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to