C
Craig
Hi... I'm trying to create a timesheet worksheet with the use of functions.
My goal is to extract (Regular, OT 1.5, OT 2, Vacations Days) out of a row
of cells. Below is a sample of my worksheet.
A B C D E F G H I J K L
1 Sun Mon Tue Wed Thu Fri Sat Reg Hours OT 1.5 OT 2 VP Days
2 Craig Off 8 8 8 8 8 Off 40 0 0 0
3 Bob Off 9 8 9 8 8 Off 40 1 0 0
4 John Off 8 12 8 VP 8 Off 32 3 1 1
I would like the cells in column "I" to add up the hours that are =<8 and to
ignor other values like VP, Off.
I would like the cells in column "J" to add the hours > 8 and =<11 also
ignoring other entries.
I would like the cells in column "K" to add the hours > 11 also ignoring
other entries..
I would like the cells in column "L" to count the VP's.
I'm using countif to count the VP's.
I was trying to use =Min() and =Max() to calculate the Reg and OT 1.5 but
using the =Min() function added 8 hours even for
days with no entries or the entry is "Off" or "VP". Using the =Max()
function I wasn't sure how extract the proper value for
OT 1.5 and OT 2.
Thank in Advance Again!
Craig
My goal is to extract (Regular, OT 1.5, OT 2, Vacations Days) out of a row
of cells. Below is a sample of my worksheet.
A B C D E F G H I J K L
1 Sun Mon Tue Wed Thu Fri Sat Reg Hours OT 1.5 OT 2 VP Days
2 Craig Off 8 8 8 8 8 Off 40 0 0 0
3 Bob Off 9 8 9 8 8 Off 40 1 0 0
4 John Off 8 12 8 VP 8 Off 32 3 1 1
I would like the cells in column "I" to add up the hours that are =<8 and to
ignor other values like VP, Off.
I would like the cells in column "J" to add the hours > 8 and =<11 also
ignoring other entries.
I would like the cells in column "K" to add the hours > 11 also ignoring
other entries..
I would like the cells in column "L" to count the VP's.
I'm using countif to count the VP's.
I was trying to use =Min() and =Max() to calculate the Reg and OT 1.5 but
using the =Min() function added 8 hours even for
days with no entries or the entry is "Off" or "VP". Using the =Max()
function I wasn't sure how extract the proper value for
OT 1.5 and OT 2.
Thank in Advance Again!
Craig