By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
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" <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

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.