Chaing a database from decs to minutes

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

Guest

I have a DB set up to monitor peoples times during their working day. This
db is set up to be in decs (i.e. an hr being 100 and not 60mins) How can I
change this so that the db works on mins and not in decs ongoing?

Thanks in advance
 
I would think that you would divide by 100, then multiply by 60. For
example, 50 is a half hour. 50 divided by 100 = .50 multiply that by 60 and
you get a result of 30.
 
Of course, as previously stated, it is not normal to store calculated
values. Personally, I store the start and stop time, then calculate the
duration in my queries, reports and forms.

For example, I have a database that tracks start work, start lunch, end
lunch, and end work. That is all I store. These are stored as times.
Then, in my queries, forms, and reports I can calculate the day's duration,
or the duration for lunch, etc. I can display this in hours and minutes, or
hours, minutes, and seconds, or total minutes, etc.

I would recommend you store the TIMES, not the DURATIONS.
 

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

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
from excel to access - a specific question 2
parameter date question 3
Access how to open existing database from another database using Access - VBA 0
charting time series with milliseconds with scatter 2
display cell content based on date criteria 2
Access Passing the value to a table 1
How to Create a CLOCK DB 0

Back
Top