Making corrections

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

Guest

I have entered a number for the hours the person worked, but it printed out as 4059987.75 and should be just 40.85. How do I make that correction?
 
I would guess the machine is right.

We need to know more. How are the time entered? What type of field is
used? What if any calculations are being done to the time.

I suspect you are hitting a problem due to rounding and or time vs.
numbers. That is 1:30 (one hour, thirty minutes) is 1.5 hours. You must
decide how you are going to go about this and not mix minutes and decimal
hours.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Waneta said:
I have entered a number for the hours the person worked, but it printed
Click to expand...
out as 4059987.75 and should be just 40.85. How do I make that correction?
 
You must log in or register to reply here.

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

Sum Hours over 24 hours in Access Report 0
Access Dcount function in access 0
Time input by work order 1
Windows 11 Windows 11 update 5
Primary Key with Symbols 5
date overlap 7
Very Strange Database Phenomena! 11
Calculate leave time in a query 4

Back
Top