Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a substitute value
I am a retail operation with 4 shifts named A,B,C,D. I use the shifts to
shedule A 8-12 - 4 hours B 10-4 - 6 hours C 12-8 - 8 hours D 3-8 - 5 hours I want excel to calculate a the total time scheduled based on the shift I enter in the spreadsheet. Looks like this: MON TUE WED... Curly A C A Larry B B B Moe D C A Total 15 22 14 Can't figure it out. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a substitute value
Try this formula. I assume you are starting in Cell A1
=COUNTIF(B2:B4,"A")*4 + COUNTIF(B2:B4, "B") * 6+COUNTIF(B2:B4, "C") * 8+COUNTIF(B2:B4, "D") * 5 HTH "Tracy D." wrote: I am a retail operation with 4 shifts named A,B,C,D. I use the shifts to shedule A 8-12 - 4 hours B 10-4 - 6 hours C 12-8 - 8 hours D 3-8 - 5 hours I want excel to calculate a the total time scheduled based on the shift I enter in the spreadsheet. Looks like this: MON TUE WED... Curly A C A Larry B B B Moe D C A Total 15 22 14 Can't figure it out. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Substitute | Excel Worksheet Functions | |||
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( | Excel Discussion (Misc queries) | |||
More than 7 IF? any substitute? | Excel Worksheet Functions | |||
Using &Chr$(39)& as substitute for ' in VBA | Excel Discussion (Misc queries) | |||
Substitute chr(39) | Excel Programming |