Caculating Currency to Time (hours:minutes) format:

[Jamie Pittman via AccessMonster.com]

I am running into a error problem I am currently using this formula with in a qurrey and it is working great.

Total Time : Format(DateDiff("n",[TimeIn],[TimeOut])\60,"0\:") & Format(DateDiff("n",[TimeIn],[TimeOut]) Mod 60,"00")

I want to be able to take the Total Time field and mutiply it to an Employee's {BASE RATE] to achive a total cost for the day????? Any suggestions with this, Really need help, getting frustrated...

--
Message posted via http://www.accessmonster.com

[pietlinden]

Jamie Pittman via AccessMonster.com wrote:

I am running into a error problem I am currently using this formula with in a qurrey and it is working great.
Total Time : Format(DateDiff("n",[TimeIn],[TimeOut])\60,"0\:") & Format(DateDiff("n",[TimeIn],[TimeOut]) Mod 60,"00")
I want to be able to take the Total Time field and mutiply it to an Employee's {BASE RATE] to achive a total cost for the day????? Any
suggestions with this, Really need help, getting frustrated...
--
Message posted via http://www.accessmonster.com

1. Convert time to minutes.
2. Divide minutes by 60 to get hours.
3. multiply by rate.

HrlyRate*DateDiff("n",StartTime,StopTime)/60

What you're doing is _formatting_. You're forcing the stuff to text
and then trying to multiply by a text value.

[Jamie Pittman via AccessMonster.com]

I still new to the access part how would I create the formula to convert to minutes? Thanks for the quick response....

--
Message posted via http://www.accessmonster.com

[Jamie Pittman via AccessMonster.com]

I figured out how to do the formula. I have another issue. When I caculate overtime, I used a yes or no check box. Is there away that if I have a employee work more than 40 hours a week that anything over that will be considered overtime????

--
Message posted via http://www.accessmonster.com

[Jimbras]

You need to work with centesimal time. 09:15 h. = centesimal 09:25.

regards

"Jamie Pittman via AccessMonster.com" <fo***@AccessMonster.com> escreveu na
mensagem news:05******************************@AccessMonste r.com...

I am running into a error problem I am currently using this formula with in
a qurrey and it is working great.

Total Time : Format(DateDiff("n",[TimeIn],[TimeOut])\60,"0\:") &
Format(DateDiff("n",[TimeIn],[TimeOut]) Mod 60,"00")

I want to be able to take the Total Time field and mutiply it to an
Employee's {BASE RATE] to achive a total cost for the day????? Any
suggestions with this, Really need help, getting frustrated...

--
Message posted via http://www.accessmonster.com