Time Sheets

[ICS]

I have created a time sheet in reports that calculates the time from a spread sheet input Time_In and Time_Out. The problem is if we work from 9:00pm till 1:00am i will get a negitive number. does any one have a answer how to do this where it wold be 4 hrs not -20

 

[PNGBill]

Should the spreadsheet reflect dates as well? ie worked 3 hrs on the 20th and 1 hr on the 21st?
Could you have a person working from 11pm Monday to 1am Wednesday. 26hrs.
Can happen in emergency situations but obviously not normal. Would mess up most calculations unless days were identified.

If yo never work on Sunday then could you just use hours eg 0 to 24 is Monday, 24:01 to 48 is Tuesday etc.

From Monday 9pm (21:00) to Tuesday 1am (25:00) = 4hrs.

Does excel have hours like it has dates ie a number rather then a date.
We use the date number to get the interval between two occurrences and this works over any period. If it covered hours then you have a value for the beginning and end f the shift and the difference is hours/minuets.

Just some ideas that may help.

 

[ICS]

In Excell you can go to 13:00 and it will calculate it right in Access it doesn't unless i am doing something wrong on the formula ie Total[Time_Out]-[Time_In])*24

 

[boblarson]

1. I normally store times with their dates so calculations are a breeze.

2. You could always do a check to see if the value is negative and if so add 12 to the starting number.

 

[ICS]

Thank you that help alot.