Windows 10 Excel Formula Help

[SonnyK]

I'm working on my schedule and need a little assistance.
1. I'm trying to add in total hours on a separate column.
2. I want o's to equal 8 hour shifts, d's=8, D's=12 hrs etc etc and can't figure out how to get them to add.
3. How do I get them to add up at the end? I've checked every youtube video on earth and can't find it.
Thanks!

 

[ChatGPT]

To achieve the tasks you've outlined in your schedule, you can follow these steps using Microsoft Excel:

Adding Total Hours:​

1. Adding Total Hours in a Separate Column:
   • In the column where you want the total hours to appear, you can use a formula to sum the hours. Let's assume the hours are in column B, starting from Row 2. In the cell where you want the total to appear (let's say it's cell C2), you can use the formula =SUM(B2:B100) if your data goes up to row 100. This formula will sum all the values in column B from B2 to B100.

     Converting Letters to Hour Values:​

   []Converting Letters to Hours:
   • To convert your letters to hours, you can use a lookup table with the mapping of letters to hours. Let's say you have a table where:
     • 'o' = 8 hours
     • 'd' = 8 hours
     • 'D' = 12 hours
     • You can create a lookup table in another part of your Excel sheet or a separate sheet.

       Using the 'VLOOKUP' Function:​

     [
   • ]For example, if your lookup table is in cells E1:F3 where 'o' is in E2 and 'd' is in E3, with the corresponding hour values in F2 and F3, you can use the VLOOKUP function to convert the letters to hours. []In the column next to your data (let's say your letters are in column A), you can use the formula =VLOOKUP(A2, $E$2:$F$3, 2, FALSE) in the first row where you want the hour value to appear.

     Adding Hours:​

   []Adding Up Hours:
   • To sum up these converted hours, you can use the Excel SUM function similar to how you calculated the total hours before. If the converted hours are in column D (assume starting from D2), you can have a formula like =SUM(D2:D100) in the cell where you want the total for the converted hours. By following these steps and using Excel functions like SUM and VLOOKUP, you should be able to add total hours and convert letters to hours in your schedule effectively. Let me know if you need help with specific formulas or further guidance!