+ Reply to Thread
Results 1 to 3 of 3

Calculate time to do a repetitive task

  1. 05-16-2018, 05:22 PM #1
    Hood
    Hood is offline
    Forum Contributor
    Join Date
    09-25-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    152

    Calculate time to do a repetitive task

    How can I calculate the time to do a repetitive task?

    For example: I know it takes an average of 0:00:45 seconds to inspect a part
    There are 64 parts to check.
    How much time will be spent to check the 64 parts?

    Thanks for the help.
    Reply With QuoteRegister To Reply
  2. 05-16-2018, 06:08 PM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Calculate time to do a repetitive task

    Isn't it...

    A1 = 0:00:45
    B1 = 64

    C1 =A1*B1

    0:48:00
    Last edited by jeffreybrown; 05-16-2018 at 06:11 PM.
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 05-16-2018, 06:56 PM #3
    Hood
    Hood is offline
    Forum Contributor
    Join Date
    09-25-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    152

    Re: Calculate time to do a repetitive task

    Yes it is. I had a cell formatted wrong causing the problem. Thanks for confirming!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate expected time to finish task
    By oranb in forum Excel General
    Replies: 12
    Last Post: 09-11-2021, 12:03 PM
  2. VBA Help for repetitive task pls help
    By kjhawkes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2016, 12:44 AM
  3. need function to calculate time spent on the given task
    By Giri.hb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2015, 04:44 AM
  4. Automate boring repetitive task
    By SpenceBasics in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-05-2012, 10:34 PM
  5. problem with macro in a repetitive task
    By mahmoodn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-03-2011, 09:20 AM
  6. Using Loops for Repetitive Task
    By fa888 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2010, 10:40 AM
  7. Need a simple VBA code to automate a repetitive task.
    By madhu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1