Re: how do you work with time?

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 05/29/04 

Date: Sat, 29 May 2004 17:56:03 -0500

Try DateDiff("n",End, Start) /60
This calculates the difference between end and start in minutes and then
divides by 60. If you need greater accuracy, you can use "s" for seconds and
then divide by 3600. 

-- 
Duane Hookom
MS Access MVP
"Annelie" <lkelady33@yahoo.com> wrote in message
news:uCK4frcREHA.3016@tk2msftngp13.phx.gbl...
> I am trying to create input for a time card
> Start: 07:44     (shorttime format)
> End: 17:13       (shorttime format)
> HoursWorked: 09:29    (shorttime format)- formula was =[end]-[start]
>
> Now how do I work with my HoursWorked
> I need to work with the hours
> I tried Int([hoursworked])
> it give me an error
> Everything I have tried gives me an error
> Help
> Annelie
>
>