Results 1 to 2 of 2

Automatic distribution of working hours

Threaded View

  1. #1
    Registered User
    Join Date
    11-05-2023
    Location
    DE
    MS-Off Ver
    365 / 2019
    Posts
    1

    Automatic distribution of working hours

    Dear members, I have the following Excel table (see attachment).

    I would like to note that my knowledge of both Excel and especially VBA is only amateur.

    Now the complicated stuff. If I enter a number at J12, I would like to enter the hours automatically, irregularly and randomly between D13 to D43 with the start of working hours, E13 to E43 with the end of working hours and F13 to F43 break.

    I've tried everything with formulas and VBA, I think it's impossible, but I've seen something similar before, so I really hope that one of you can help me.

    Thanks in advance!!
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating Day Night hours distribution
    By Dyakov in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-06-2022, 07:01 AM
  2. Automatic generation of Mark distribution
    By meetgilbert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-24-2019, 10:58 AM
  3. Problem with NORMSDIST and distribution of hours
    By RE_NERO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-31-2014, 10:29 PM
  4. Replies: 3
    Last Post: 10-10-2013, 10:15 PM
  5. Elapsed working hours, without counting weekends or non-working hours
    By ebkiwi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2013, 04:18 PM
  6. [SOLVED] Calculate hours with predefined Working Hours and Weekend Hours
    By garciapliz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-05-2013, 11:17 AM
  7. Replies: 2
    Last Post: 06-14-2013, 10:45 AM

Tags for this Thread

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