434,849 Members | 2,169 Online
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

Caculating Currency to Time (hours:minutes) format:

 P: n/a 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 Nov 13 '05 #1
4 Replies

 P: n/a 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. Nov 13 '05 #2

 P: n/a 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 Nov 13 '05 #3

 P: n/a 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 Nov 13 '05 #4

 P: n/a You need to work with centesimal time. 09:15 h. = centesimal 09:25. regards "Jamie Pittman via AccessMonster.com" escreveu na mensagem news:05******************************@AccessMonste r.com...I am running into a error problem I am currently using this formula with ina 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 Nov 13 '05 #5