# Formula Issue

Options
✭✭✭✭✭✭

I am attempting to calculate how many hours total worked from columns "Requested Start Date", "Requested End Date" and "Requested Hours".

This way I can figure out if hours are under 4 (hrs.), if it is a weekend and what weekend day it is for example "Saturday" or "Sunday".

Is there an easier way and I have been looking at this too long now?

Options

It looks like you're attempting to divide an entire column range ([Requested Hours]@row:[Requested Hours]@row) instead of just the one cell in the current row ([Requested Hours]@row)

Try this:

=IF([Time of Day Reqs]@row = "After Hours", "N/A", IF([Requested End Date]@row - [Requested Start Date]@row < 1, [Requested Hours]@row / ([Requested End Date]@row - [Requested Start Date]@row + 1)))

I also added parentheses around what you want to divide by.

Let me know if this works for you, now!

Cheers,

Genevieve

Options

It looks like you're attempting to divide an entire column range ([Requested Hours]@row:[Requested Hours]@row) instead of just the one cell in the current row ([Requested Hours]@row)

Try this:

=IF([Time of Day Reqs]@row = "After Hours", "N/A", IF([Requested End Date]@row - [Requested Start Date]@row < 1, [Requested Hours]@row / ([Requested End Date]@row - [Requested Start Date]@row + 1)))

I also added parentheses around what you want to divide by.

Let me know if this works for you, now!

Cheers,

Genevieve

• ✭✭✭✭✭✭
Options

@Genevieve P. - I see my extra add-in and understand that was a cell by cell instead of the row. Thank you, the formula you provided cleared up my "Invalid Operation". The only bit I am missing is the actual hours from the Requested Start Date and Requested End Date so Hours Worked technically should be showing 32 is there more to the current formula that I should be adding in or I am missing?

I have attempted a few other variables in the formula provided

BUT when I did I received this

Options

Can you detail exactly what you want the formula to return?

Right now it's taking the Requested Hours and dividing it by the Number Of Days (Start to End).

Is that what you're looking for, to see how many hours per-day? Are you wanting to include Weekend Dates into the equation (ex. if the Start is on Friday and End is on Monday, is that 2 or 4?)

• ✭✭✭✭✭✭
Options

I am looking to see how many hours per day based on an 8 hour day during the weekday.

I have a weekend column(s) separately that I have not started working on just yet, thinking they may be similar to the weekday.