Calculating Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My program is an input form for employee timesheets.
I have 2 combo boxes, User enters "Time In' in one and "Time Out" in the
other.
(ie: 8:00am IN, 4:30PM OUT) datatype is date/time.
How do I calculate the total time worked down to the minute?

thank you.
 
Much thanks! this link provided a great solution, please I need further
assistance on same matter. This function was provided from your link:
Hours: Format([TimeIn]-1-[TimeOut],"Short Time")

TimeIn TimeOut Hours
8:00:00 AM 4:30:00 PM = 08:30

I now need to multiply the above calculated elapsed time by the hourly rate
of an employee to get their pay. (ie: 10.00 X 08:30 ). However due to the
formula being currency times time data type, it of course doesn't work. I've
tried all kinds of formatting but am stumped to make it work, how can or
should this be done?

thank you!
 
Here's a link that my be better suited for your issue:
http://www.pacificdb.com.au/MVP/Code/DiffTime.htm
Much thanks! this link provided a great solution, please I need further
assistance on same matter. This function was provided from your link:
Hours: Format([TimeIn]-1-[TimeOut],"Short Time")

TimeIn TimeOut Hours
8:00:00 AM 4:30:00 PM = 08:30

I now need to multiply the above calculated elapsed time by the hourly rate
of an employee to get their pay. (ie: 10.00 X 08:30 ). However due to the
formula being currency times time data type, it of course doesn't work. I've
tried all kinds of formatting but am stumped to make it work, how can or
should this be done?

thank you!
[quoted text clipped - 9 lines]
 
At least one reply in a more recent thread. You should confine your question
to a single thread.

--
Duane Hookom
MS Access MVP

Bret said:
Much thanks! this link provided a great solution, please I need further
assistance on same matter. This function was provided from your link:
Hours: Format([TimeIn]-1-[TimeOut],"Short Time")

TimeIn TimeOut Hours
8:00:00 AM 4:30:00 PM = 08:30

I now need to multiply the above calculated elapsed time by the hourly
rate
of an employee to get their pay. (ie: 10.00 X 08:30 ). However due to
the
formula being currency times time data type, it of course doesn't work.
I've
tried all kinds of formatting but am stumped to make it work, how can or
should this be done?

thank you!

ruralguy via AccessMonster.com said:
Maybe these links will help:
http://www.mvps.org/access/datetime/date0004.htm
http://www.mvps.org/access/datetime/date0009.htm

Displaying the results down to the minute is just a Format() function.


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculated minus breaks & lunch 2
TIME CALCULATION 5
Sum Times 3
Excel Time Rounding in Excel 2
formatting time cell 3
TIME SHEETS 1
time calculation problem 18
Converting Time Calculation to Decimal 5

Back
Top