Please help with deadlines!!!!!!

[heskett center]

My company is going through an upgrade process where we are migrating from Mac to Windows. As part of the process, our database is of course has to be move to Windows. We recently purchased Filemaker Pro 8.0 as an upgrade from the old Filemaker Pro 2.0 (Mac version)

Ok! Enough with the history. I was given the task of moving and upgrading to Filemaker Pro 8.0. We have 30 employees and 2 different work areas. Each is assigned with his/her own building number. My objective is simple: I have to develope clock-in layout that can keep track of how many hours an employee works, how much he/she makes in 2 weeks and how much we make in each area.

In order to do that. I've created a list of all the employees' names and building numbers. Next I use relation to connect the building number to the clock-in layout. I managed to make it works. FM was able to display the correct name of the employee. But here's the trouble:

My workplace use the military-time-system for doing clock-in. Example: Let's say Bob works from 1 to 3:30 in the afternoon. We would put in FM 13 as in time and 15.30 as out time and the total hours work would be 2.50. Below are our time-system:

1:00 = 1 hour

1:15 = 1.25 hours

1:30 = 1.50 hours

1:45 = 1.75 hours

I try to use the calculation field: Total Hours Worked = Out time - In time. But FM only displays the math amount not the time-systme results as I've mentioned above. Example: Let's use the Bob example again, after calculation FM would display 2.30. Because 15.30 - 13 = 2.30. Which is correct in a math sense but I want the result to come out as 2.50 according to our time-system.

Please help me out all of you Filemaker gurus out there. My deadline is a couple days away and I can't seem to figure this out.

[comment]

1. Please do not double-post (or, in your case, triple-post).

2. I believe this should answer your question.

3. I doubt migrating from Mac to Windows is "an upgrade process".

[heskett center]

Thank you so much for you reply and let me apologize for posting multiple posts. This is my first time in this forum therefore I'm not familiar with the rules here.

I've tried what you suggested but it didn't work for me. My results turn out to be one continuous number. Below is a pix to show u what i mean.

Or u can click this link if you can't see the image:

Clocking in Problem

Edited October 16, 2006 by Guest

[comment]

It doesn't work because your In/Out fields are not TIME fields. Why is that?

[heskett center]

I got it thank you so much for your help. You wouldn't know how much that help me out.