J
Jaytee
I set up a timecard for myself, in which I input a start and end time, and
through subtraction, arrive at a number of hours worked.
A B C
1 9:00 AM 5:00 PM 8.00
2 8:30 AM 5:00 PM 8.30
3 TOTAL: 16.30
Trouble is I get funky totals, because, I suspect, the C column is giving
times instead of a number of hours. So it's adding 8:00 am to 8: 30 AM and
telling me I only worked a half hour. Any ideas? The total should be total
hours worked.
through subtraction, arrive at a number of hours worked.
A B C
1 9:00 AM 5:00 PM 8.00
2 8:30 AM 5:00 PM 8.30
3 TOTAL: 16.30
Trouble is I get funky totals, because, I suspect, the C column is giving
times instead of a number of hours. So it's adding 8:00 am to 8: 30 AM and
telling me I only worked a half hour. Any ideas? The total should be total
hours worked.