Results 1 to 2 of 2

Thread: Excel 2010 - Help with making 'Standby' apply as 7.2 in formula - Possibly: Change Event (VBA)

  1. #1
    Join Date
    Feb 2012
    Posts
    4

    Excel 2010 - Help with making 'Standby' apply as 7.2 in formula - Possibly: Change Event (VBA)

    Hi All,

    This is my first official post so please bare with me.

    PROBLEM:

    I am trying to create a speadsheet which is a timesheet. I have two versions, one is a simple table that the guys put in their total daily hours or write 'Standby' when they are on standby i.e.

    Mon 12
    Tue 12
    Wed Standby
    Thu 12
    Fri 12


    On the other I have the hours split into Standard and Overtime using the min and max functions which works out a min standard day of 7.2 hrs and anything over as o/t. This all works fine.

    The issue I'm having is that when they write 'Standby' I want it to return in my otherspreadsheet as 7.2 in the standard hours column. I think the answer is to write a change event on VBA but this is beyond me. Can anybody help write the change event formula and give me a step-by-step on how to apply it or suggest another way? (I have tried Define Name and it doesn't apply... as I want to further calculate the total hours etc)

    Much appreciated!!!

  2. #2
    Join Date
    Feb 2012
    Posts
    4

    Re: Excel 2010 - Help with making 'Standby' apply as 7.2 in formula - Possibly: Change Event (VBA)

    Update:

    I've taken a different angle and added a 'Standby hours' column which formulates as a COUNTIF times the hours per day

Similar Threads

  1. Formula to Calculate Rate of Change in Microsoft Excel
    By Lanka Boy in forum MS Office Support
    Replies: 2
    Last Post: 14-01-2012, 03:49 PM
  2. Replies: 1
    Last Post: 13-01-2012, 05:09 PM
  3. excel 2010 formula
    By mr.dale in forum Windows Software
    Replies: 3
    Last Post: 06-03-2011, 10:47 PM
  4. How to apply more than one formula to single column?
    By REDBULL in forum Windows Software
    Replies: 5
    Last Post: 15-12-2009, 08:05 AM
  5. Excel formula
    By Me Me Taylor in forum Windows Software
    Replies: 2
    Last Post: 06-04-2009, 04:11 PM

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
  •  
Page generated in 1,643,111,599.60322 seconds with 17 queries