Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

time calculation on form

i have attached sample db- open and a form comes up-
in is 8:00 am
out is 11:00 am
when you hit calculate button now it displays 3 - for hours between in and out-
If you look at calculate button code- you see i have 30 minutes being subtracted.
( if i have written code correctly)
Is there a way to display the decimal values in monday text button?
right now it displays 3
i want it to display 2.50
thank you
test20.mdb
0
davetough
Asked:
davetough
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
test this
test20Rev.mdb
0
 
Rey Obrero (Capricorn1)Commented:
you have to use Single for the Field size of field Dmonday in the design view of your table
and use this calculation
Me.txtMonday = (DateDiff("n", Me.txtMonIN, Me.txtmMonOUT) - 30) / 60
0
 
davetoughAuthor Commented:
Thanks for solution and explanation
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now