Results 1 to 7 of 7

Formula for time displayed within a staff rota

Threaded View

~TaC~ Formula for time displayed... 11-13-2018, 05:45 PM
XLent Re: Formula for time... 11-14-2018, 06:43 AM
~TaC~ Re: Formula for time... 11-15-2018, 05:09 AM
kvsrinivasamurthy Re: Formula for time... 11-14-2018, 09:32 AM
~TaC~ Re: Formula for time... 11-15-2018, 05:13 AM
XLent Re: Formula for time... 11-15-2018, 05:42 AM
~TaC~ Re: Formula for time... 11-15-2018, 06:18 AM
  1. #1
    Registered User
    Join Date
    11-12-2017
    Location
    Stafford, England
    MS-Off Ver
    365
    Posts
    184

    Formula for time displayed within a staff rota

    Hi,

    Reopening a project you guys have previously helped me with, everything you did works well but I am just looking for a slight amendment.

    I have attached the project and removed sensitive data, sheet 2 & 3 are locked as these need no change.

    Sheet 1 Tuesday onward is not needed so again cells are locked.

    This example focuses on sheet 1 cells C3:T38 and V3:W38 and I think its the formulas in columns V&W that need amending.

    V6:Y7 show the results I am looking for but I want this to be true when the data in D9:R10 is used and not the data currently used as in D6:R7.

    Basically it already works exactly as I want except I want,
    0.25 in D6 to result 6.45 in V6
    0.75 in L6 to result 14.45 in W6
    0.75 in J7 to result 12.15 in V7
    0.25 in R7 to result 20.15 inR7

    This is to fall in line with things already used in my workplace, otherwise I would use it as it is.

    Thanks
    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. [SOLVED] how do I get my staff rota to add number of staff on duty
    By dougers1 in forum Excel General
    Replies: 2
    Last Post: 07-20-2017, 05:18 AM
  2. Replies: 14
    Last Post: 05-23-2015, 06:26 AM
  3. Staff rota
    By chelfox in forum Excel General
    Replies: 1
    Last Post: 10-07-2013, 11:25 AM
  4. [SOLVED] Formula Query for Staff Rota
    By bigtiger1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-02-2013, 07:33 AM
  5. [SOLVED] Formula for male and female staff on rota
    By bigtiger1 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-06-2013, 07:03 AM
  6. [SOLVED] A formula to work out hours on a staff rota
    By bigtiger1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2013, 07:23 PM
  7. Replies: 0
    Last Post: 06-12-2013, 03:33 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1