Help on a convertion

[Guest]

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.

 

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

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]

 

[Guest]

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

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.

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]

 

[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

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]