Search results

I am having trouble understanding the suggestions. If with my original formula, an individual worked 7.55 hours, the person keying the information needs to see that they worked 7 hours 35 minutes, rounded to 7 hours 30 minutes (7.30). So it will always be total hours and minutes worked...

Good evening, Using the DateDiff formula I have been calculating the total time worked. I need to round this formula to the nearest quarter of an hour. How can I amend my formula =DateDiff("n",[StartTime],[EndTime])/60 to achieve this? Thanks in advance for your response.

Thanks for your reply. The problem I'm having is that there are 3 subform subtotals on the main form...one totaling time based work, one totaling task based work and one totaling other work. When I enter time based work in one record, and task or other work in the next record, the subtotal for...

Hi Further to this earlier post, I have encountered a slight problem. Due to the number of fields in my subform, datasheet view was too wide and difficult to navigate and simply did not look good. I changed the subform from datasheet to single form and once I did this, the sub-total on the...

Will do that from now on! On another note, please let me know if I am posting the formulas correctly - do I wrap code, or quotes around the formulas before posting?

Thank you! That last formula worked. I had just finished typing out a long response to your previous post with examples and everything and then accidentally clicked refresh page and lost everything I type :( Thanks again...you've helped me out a lot!

What's happening is that the formula is adding 50 to every line in the record that is NOT time based. So the record that had no time based work, but 4 task based work, is returning a result of 200.00 in the time sub-total I need to find a way of saying if the time controls are blank, to return...

Ok...I'm getting somewhere. The formula is being accepted but the total is incorrect. So I will keep working with the NZ function to see if I can get the end correct end result. Thank you for your help.

I'm not getting the formula to work, I'm getting invalid dot or operator message. I've gone over the formula a few times now and can't find the problem

Another Subtotal Formula in Subform Problem (DateDiff Forumula) I have another sub-form subtotaling issue. I am entering work that is task based, time based or other. The below sub-total formula was working until I came to a record that had no time based work at all. The sub-total control...

Thank you. That worked. Changed the formula to the below and now everything is summing correctly =Sum(DLookUp("[Rate]","tblPrograms","PrgmID=" & [PrgmID])*[Qty]) Thank you very much :)

Hi, I have an invoice form in which there are 3 categories of works - time based, task based and other. For task based, there is a Dlookup formula that looks up the program used and applies a rate to the work. The problem I am having is subtotalling the tasks in the forms footer, so I can see...

Made a slight change to the formula in the subform; below is the corrected final sub-total formula =50*(Sum(DateDiff("n",[StartTime],[EndTime])/60)-1)+50 Thanks again for your help

THANK YOU! Including the datediff formula worked! So below is the final formula =Sum(((DateDiff("n",[StartTime],[EndTime])/60)-1)*50)+50 Thank you so much :)

Thanks but still getting #Error

Good night, I have been struggling to show a subtotal in the footer of an invoicing subform. The subform has the following text boxes [StartTime] [EndTime] The standard rate is $50.00 for the first hour or part thereof; $50.00 per hour thereafter. I have calculated the time elapsed using the...

Figured it out...so simple an error it is embarrassing As I was working with dates, I had the number format set to custom so when I entered this formula it was trying to convert it to a customized date format. I changed it to number with 0 decimal places and it worked.

I am setting up a vacation roster and was using the networkdays.intl formula to calculate the number of days used per employee per month, excluding Saturdays, Sundays and bank holidays. The formula was working until I got to one employee who went over the number of due days for the year, using...

Thanks again...it's a little too complex for my level. Did some more searching and modified my original formula and found something that is easier for me and (so far) is giving the results I was looking for. =INT(MROUND(CELLREF,1/16)/12) & "' " & TEXT(MOD(MROUND(CELLREF,1/16),12),"#-#/##")

Good Morning, Is there a formula to convert a number to feet and inches with fractions. For example I would like to convert 143.625 to 11 ft 11 5/8 in. I was using this formula - =INT(CELLREF/12) & " ft. " & MOD(CELLREF,12) & " in." but can't find a way to include for fractions.