noon

Good Evening, I have a formula here that calculates the time difference from one date to another. It should spit this back in whole hours and it does. However, if I go over 23 hours (i.e. noon to noon), it goes back to zero because I think it's taking out a day. I need it to be able to hit 24+...

Just picking up this piece of coding after leaving it for 4 months....I want to remind myself so I correctly modify it.... The coding works as it should, but here is what it should be doing: It checks if the previous sheet is called "Noon#" (meaning Noon or Noon2, Noon 3, etc) then adds N14...

I have a workbook that creates sheets named "Noon", "Noon2", "Noon3" etc based on the users' needs (button will generate a new "Noon" on demand. I'd like a piece of code that will delete all sheets named "Noon+# so that the original template is not saved over. How might I do this. I presume...

Someone on here wrote this for me and I haven't been able to get back in touch for a few questions. Basically this is supposed to add the figures in Cell N10 from all sheets named "Noon" + Index # (i.e. Noon, Noon2, Noon3, Noon4 etc) as well as from R17 from the "Arrival" Sheet. The total for...

Good Afternoon- I'm trying to figure a code to go through the following processes: I'd like to open Excel- Initial sheet is the Master Template- 1. A dialog box opens with a series of inputs (They establish the "constants" in the formulas) 2. Then Either Sheet 1 "Noon" or the Totals...

Ok I've got (what I consider to be) a challenge problem. I have a workbook with 11 worksheets that are used (there are more but not printed). FYI- I have a I was wondering if someone could write a macro code, or series of codes, that with the ActiveCommand buttons I've put in: "Noon" -...

Hello All, So I am trying to determine how many orders my provider entered by noon, also how many discharge orders entered by noon. It seems Access has two common criterias I can use, And is one, and Or is another. I want a query that gives me both the numbers of orders and discharges...