[FONT="]I have a spreadsheet that I’m using to calculate hours worked. column headings are ”Clock In”, “Meal Hour 1”, “Meal Hour 2”, “Meal Hour 3”, ”Meal Hour 4“ & “Clock Out”. After the clock out time there are Stright Time Hours Worked, Time & 1/2 Hours Worked, and Doubletime Hours worked. I want to use a formula that will automatically calculate the correct number of hours for each heading. [/FONT]
[FONT="]
[/FONT]
[FONT="]Straight Time are any hours worked between 8am-12pm, and 1pm-5pm. [/FONT]
[FONT="]Time & 1/2 are any hours worked between 7am-8am, 5pm-6pm, 7pm-12pm, & 1am-6am. [/FONT]
[FONT="]Double Time are any hours worked during those breaks which are 6am-7am, 12pm-1pm, 6pm-7pm and 12am-1am. [/FONT]
[FONT="]
[/FONT]
[FONT="]Right now I manually calculate the hours for each and fill it in but I would like to automate that process if at all possible using the clock in and clock out fields. I’ve tried conjunctive IF statements and AND/OR but I’ve had no luck. Can anyone point me in the right direction?[/FONT]
[FONT="]
[/FONT]
[FONT="]Straight Time are any hours worked between 8am-12pm, and 1pm-5pm. [/FONT]
[FONT="]Time & 1/2 are any hours worked between 7am-8am, 5pm-6pm, 7pm-12pm, & 1am-6am. [/FONT]
[FONT="]Double Time are any hours worked during those breaks which are 6am-7am, 12pm-1pm, 6pm-7pm and 12am-1am. [/FONT]
[FONT="]
[/FONT]
[FONT="]Right now I manually calculate the hours for each and fill it in but I would like to automate that process if at all possible using the clock in and clock out fields. I’ve tried conjunctive IF statements and AND/OR but I’ve had no luck. Can anyone point me in the right direction?[/FONT]