| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for adding values that have a letter at the end in Excel 2
We use 3 letter codes (A, S, P) for leave taken by an employee. The number
of hours is entered as H:MM, then the letter leave code (e.g., 1.45A, 2.30S, 4:15P). I need a formula to add the total number of hours in each row for the three letter codes. I have spent hours searching for formulas online and am not sure which functions to use (SUMIF, SUM, etc.) I also need a formula that would convert the a total number of leave hours e.g., 147.70=148.10, 1233.89=1234.29, 602.97=603.37. Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding letter at the end of cell | Excel Discussion (Misc queries) | |||
| Adding up letter values | Excel Discussion (Misc queries) | |||
| Dificulty adding alphanumeric values either one letter or two | New Users to Excel | |||
| Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
| My first post - Please Help (Formula for adding Values) | Excel Discussion (Misc queries) | |||
Threaded Mode
