+ Reply to Thread
Results 1 to 3 of 3

[SOLVED ON MY OWN] Formula to calculate total hours based on a changing set of variables

  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    houston
    MS-Off Ver
    Texas
    Posts
    19

    [SOLVED ON MY OWN] Formula to calculate total hours based on a changing set of variables

    I'm looking for a macro that copies the current active calculation, creates and inserts an identical one with working formula and makes the original columns values only with no formulas and then add the two totals hours together.
    Attached Files Attached Files
    Last edited by cprice4407; 06-01-2018 at 11:29 AM.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Total hours

    Read forum rules first: https://www.excelforum.com/forum-rul...rum-rules.html

  3. #3
    Registered User
    Join Date
    06-26-2015
    Location
    houston
    MS-Off Ver
    Texas
    Posts
    19

    Re: Total hours

    Thank you for the link. Very helpful.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to calculate hours worked w/lunch or w/o + OT column only total after 40 hours
    By blinhart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2023, 11:14 AM
  2. Count total of staff hours excluding hours for any leavers
    By FraserMc97 in forum Excel General
    Replies: 1
    Last Post: 04-05-2017, 11:44 AM
  3. Replies: 5
    Last Post: 06-30-2016, 08:37 AM
  4. Help Please...!! How To Separate Regular & Overtime Hours From Total Monthly Hours
    By iffyxalone in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2016, 08:55 AM
  5. Replies: 1
    Last Post: 06-29-2016, 08:55 AM
  6. [SOLVED] Formula needed to total daily work hours and hours per week
    By amkampbell in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2016, 07:33 PM
  7. [SOLVED] Formula Calculated total work hours - now need to remove breaks and standard hours?
    By smeem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2014, 12:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1