# Calculating END time based on start time, breaks, and hours to complete

1. ## Calculating END time based on start time, breaks, and hours to complete

I need help creating a macro that will use Cell A1 (now()), the penalties (amounts of breaks) per hour listed on the penalties tab, and the input data of hours and minutes to determine a completion time.

The thing where I get confused is we have different "breaks/penalties" depending on the day of the week. I have listed all of those in the penalties tab.

The Calc form B9 and B10 are what I want to populate with the macro.

Can anyone help?

Erin:

2. ## Re: Calculating END time based on start time, breaks, and hours to complete

I would really appreciate any help on how to do this?

3. ## Re: Calculating END time based on start time, breaks, and hours to complete

Should the winding and connecting end times be calculated?

4. ## Re: Calculating END time based on start time, breaks, and hours to complete

yes - the connecting cannot begin until the winding has ended

5. ## Re: Calculating END time based on start time, breaks, and hours to complete

Basically what happens is they wind and then they start connecting and we need what time it will be at the end of each of those processes

6. ## Re: Calculating END time based on start time, breaks, and hours to complete

I have been thinking about it and I think my logic needs to be to look at the start time and and an hour - but then subtract the penalty times, then do the amount of hours for time given to complete the task and subtract 1, and run that through a while loop until the the amount of hours to complete is 0. I am just not sure what the syntax for this would be

7. ## Re: Calculating END time based on start time, breaks, and hours to complete

sorry - I think I replied to this incorrectly. The connecting can't begin until the winding has ended. Do you have any suggestions? ANY help is greatly appreciated

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

#### Posting Permissions

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

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.06423 seconds
• Memory Usage 8,971KB
• Queries Executed 15 (?)
Template Usage (32):
• (1)footer
• (1)forumrules
• (1)gobutton
• (7)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (1)postbit_attachment
• (7)postbit_legacy
• (7)postbit_onlinestatus
• (7)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php
• ./includes/functions_notice.php

Hooks Called (47):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_attachment
• postbit_display_complete
• memberaction_dropdown
• tag_fetchbit_complete
• forumrules