Hello,
I'm fairly new to Excel, but I can manage and am a fast learner. Recently I was put to the task of creating a spreadsheet that could calculate overtime and include a column which would only add the hours that were equal to or fell between a date range. I've figured out how to calculate the overtime... I'm just having trouble returning the value from the total hours for a particular day, if it falls within a date range.
See attached spreadsheet...
Cell H6 contains the formula I am having trouble with.
=IF(AND(B6 falls between the value of B3 or value of D3),G6,0)
B3 = Start of Payroll
D3 = End of Payroll
B6 = Current Date
G6 = Total of Hours
H6 = Total of Hours that fall between date range (B3,D3)
What am I doing wrong? View attachment 2Timesheet with OT Calculation.xlsx
I'm fairly new to Excel, but I can manage and am a fast learner. Recently I was put to the task of creating a spreadsheet that could calculate overtime and include a column which would only add the hours that were equal to or fell between a date range. I've figured out how to calculate the overtime... I'm just having trouble returning the value from the total hours for a particular day, if it falls within a date range.
See attached spreadsheet...
Cell H6 contains the formula I am having trouble with.
=IF(AND(B6 falls between the value of B3 or value of D3),G6,0)
B3 = Start of Payroll
D3 = End of Payroll
B6 = Current Date
G6 = Total of Hours
H6 = Total of Hours that fall between date range (B3,D3)
What am I doing wrong? View attachment 2Timesheet with OT Calculation.xlsx