Help on a convertion

N

NHen13

I am working on a timesheet and have figured out how to compute the time but,
the company I work for states the time in thirds. ex 0-9 mins = 0, 10-29
mins. = .33, 30-49 mins. = .67 and 50-60mins. = 1 hour. I feel like i should
know this but it just isn't comming to me. Please Help.
 
J

John Vinson

I am working on a timesheet and have figured out how to compute the time but,
the company I work for states the time in thirds. ex 0-9 mins = 0, 10-29
mins. = .33, 30-49 mins. = .67 and 50-60mins. = 1 hour. I feel like i should
know this but it just isn't comming to me. Please Help.
Click to expand...

Are you trying to convert thirds to time? or vice versa? What is your
input, and what is your desired output?

If you're being given a time and need to calculate the "thirds", try
the Switch() function:

Thirds: Switch(Minutes([timefield]) <= 9, 0, Minutes([timefield]) <=
29, 0.33, <etc>


John W. Vinson[MVP]
 
N

NHen13

For example, someone takes off at 11:00Am and returns at 2:30PM. Accounting
for the lunch hour that person was off for 2.30 (after using the Format
function from other posts) I need to chang that to 2.33. I know it sounds
silly but thats government

John Vinson said:
I am working on a timesheet and have figured out how to compute the time but,
the company I work for states the time in thirds. ex 0-9 mins = 0, 10-29
mins. = .33, 30-49 mins. = .67 and 50-60mins. = 1 hour. I feel like i should
know this but it just isn't comming to me. Please Help.
Click to expand...

Are you trying to convert thirds to time? or vice versa? What is your
input, and what is your desired output?

If you're being given a time and need to calculate the "thirds", try
the Switch() function:

Thirds: Switch(Minutes([timefield]) <= 9, 0, Minutes([timefield]) <=
29, 0.33, <etc>


John W. Vinson[MVP]
Click to expand...
 
J

John Vinson

For example, someone takes off at 11:00Am and returns at 2:30PM. Accounting
for the lunch hour that person was off for 2.30 (after using the Format
function from other posts) I need to chang that to 2.33. I know it sounds
silly but thats government
Click to expand...

Hmmm... try this:

TimeOff: CLng(DateDiff("n", [TimeOff], [TimeOn]) / 20) / 3.

The DateDiff expression will get the time in minutes; dividing by 20
and using CLng() will convert to an integral number of 20-minute
periods; dividing this value by 3 will convert to fractional hours.

John W. Vinson[MVP]
 
Top