# Excel Formulas

Questions related specifically to the use of Excel formulas.

1. ### Sum extra hours worked before today and subtract leave hours based on text string2

• creativespace
2. Replies
2
Views
616
2

• abs_brum
2. Replies
2
Views
571
2
1. ### sum up the x in range to give proper percentage calculation1

• megatronixs
2. Replies
1
Views
608
1
1. ### Finding Working Day from the Calendar Date using a formula1

• kumuda2505
2. Replies
1
Views
465
1

• jnepsa
2. Replies
4
Views
763
4

• Gemma86
2. Replies
6
Views
1.2k
6
1. ### AverageIf #DIV/0! error10

• Murph0625
2. Replies
10
Views
3.4k
10

• dRaz
• dRaz
2. Replies
10
Views
1.5k
10
1. ### Removing Characters out of a long string of characters via formula5

• DaveSharpe79
2. Replies
5
Views
713
5

• JohnDrew
2. Replies
5
Views
996
5
1. ### Convert Time into Hours in Excel1

• DaveSharpe79
2. Replies
1
Views
455
1
1. ### Return "YES" if cell H2 >12 and cell P2=Open - If no match return "NO"5

• MantaLady
2. Replies
5
Views
727
5

• skeeeter
2. Replies
3
Views
591
3

• jask
• jask
2. Replies
1
Views
668
1
1. ### Formula to count times a specific number will divide into another + rounding rules1

• j6bennett1
2. Replies
1
Views
441
1

• CCA BSM
2. Replies
3
Views
6.8k
3

• clariinc
2. Replies
2
Views
698
2
1. ### select by data validation list to highlight the cells15

• sathishsusa
2. Replies
15
Views
2k
15

• Gyster
2. Replies
1
Views
510
1
1. ### Power Forecast Formula Errors Out on Legitimate Value3

• JamesRyann
2. Replies
3
Views
753
3