I need to calculate the number of hours between 8 a.m. and 5 p.m. less one hour for lunch so the total hours for the day is 8. This is for the Holiday Pay column on our office timesheet. I have part of the formula which is =(J3-I3)*24-1, but it doesn't work on days where there isn't any time entered. It automatically calculates it as -1. Is my formula incorrect?
Give this a try:
Cheers,
=IF(J3-I3<1,0,(J3-I3)*24-1)
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Try this:
=IF(SUM(I3:J3)=0,0,(J3-I3)*24-1)
Assuming that you only want to calculate the hours when both cells are populated try
=IF(COUNT(I3,J3)=2,(J3-I3)*24-1,"")
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks