Ask Experts Questions for FREE Help !
Ask
    Big10706's Avatar
    Big10706 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jul 15, 2009, 06:24 PM
    Creating a work schedule using Excel
    I need help devising a formula to add hours to a schedule. I have everything complete except for the formula to calculate an overnight shift 10:00 pm to 6:00 am. The trick is to combine this formula in the formula's for the other shifts as well, which include 6:00 am to 2:00 pm and 2:00 pm to 10:00 pm. I need to incorporate it all together. I hope someone understands what I'm trying to ask. I can't just separate the formula's because everyone is flexible with their schedule so they work all three shifts.

    Thanks for your help guys! :D
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jul 15, 2009, 11:45 PM
    Code:
      a           b          c
10:00 am    6:00 pm    8:00
10:00 pm    6:00 am    8:00

    =B1-A1+(B1<A1)

    Format the cells with this formula as [h]:mm

    Perhaps this, just to make sure that both time values are there before doing the math:

    =IF(ISBLANK(B1),"",B1-A1+(B1<A1)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel - Creating a link from on cell/tab to another IN THE SAME FILE [ 4 Answers ]

I am trying to find a way to make a hyperlink in a cell that links to either another cell on the same tab or a cell on another tab WITHIN the same Excel file. Any ideas? EDIT: I want a word in one cell that is a hyperlink so that when a user clicks on it, it will JUMP to another cell or...

Work out routine schedule pictures [ 4 Answers ]

How do we follow up a work out routine? (with pictures included)

Creating a fornula in excel to find a percent of something [ 2 Answers ]

Billable makes up two cells H&I and $=4% labor is J I make $250.00 billable and I need to fine the percentage for my Commission in J I need a formula that will allow me to get 4% if billable and put the answer in Comm (j) Billable 4% 10% Materials Comm. Labor Comm.

Creating a Chart in Excel by including values in X and why Axis [ 2 Answers ]

1) I want to create a chart using the data in my excel sheet. 2) Data in Row 1 should become the x-axis labels in a chart and data in Row 2 should be the y-axis labels and the only data range actually in the chart. 3) When I highlight data in Rows 1 and 2 then click on Chart Wizard both data ...

View more questions Search