Chaing a database from decs to minutes

T

Tosh1977

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
 
R

Rick B

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.
 
R

Rick B

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.
 
Top