Time to number

[Leather Knight]

I have 3 fields

1) Time In

2) Time Out

3) Total Hours

I know this sounds basic, but I am getting crazy figures in the total hours. I did the Total Hours as a number with a calculated value of Time Out - Time In. I thought it would be a simple calculation, but it comes up with things like -12987 when I put in the time in as 07:00 and the out as 18:45. Any suggestions??

[comment]

What do you want the result to be, when Time In is 07:00:00 and Time Out is 18:45:00?

[Leather Knight]

It should say, 11.75

[comment]

Then try:

( Time Out - Time In ) / 3600

[Vaughan]

What should the calculation return when somebody does a late night shift and the time in is 18:45:00 and time out is 07:00:00?

You need to track date in and date out as well and include these into your calculation. Something like:

( ( ( Date Out - Date In ) * 86400 ) + ( Time Out - Time In ) ) / 3600

[Leather Knight]

Good point.. Ok now the fields I have are this:

1) Time In

2) Time Out

3) Date (for the starting date)

4) Date2 (For the ending date)

5) Total Hours

6) Pay Rate

7) Overtime

8) Overtime Weekly

*******

Now I have it set to record my daily time sheet, and need to make sure that if the hours are over 10 in one day all hours over the 10 for a single day are at time and a half. I also need to have "Overtime Weekly" to check if the total hours for the "Pay Period" is over 40, and if so, all over 40 would be at time and a half.

Complicated at best. Since if over 10 is 1.5 and over 40 is 1.5... I may be in over my head on this one...

I am including the file so you can see what I am trying to accomplish. It is for my personal timesheets.

timesheet.zip