Search results

There needs to be one more " after the second h (should read h"h" m"m"), but this works! Thank you very much!!! Greatly appreciate your help. Chris

I have time listed as 6:48:47 AM, but want to display it as 6h 49m. I have not been able to format the cell to appear like this. Is there a format that I am missing or a formula that can help me do this? Thank you. Chris

I receive a separate report for each month and the time values by project, by person is the data I am attempting to capture so that I can build a cumulative graph for the entire year. So, I will get data similar to what I posted in January, for instance, but all of the employees and projects...

Sure, Narayan, and thank you, all, for continuing to provide me feedback/help. I greatly appreciate it. Below is how my report is being given to me for one month (I changed the names to protect the innocent). Column A is "Person/Project" and Column B is "Time (decimal). Person/Project...

Thank you for this suggestion. I searched the site and found the article you are referring to. So, I tried it out, but got a "1" after everything, no matter if it was listed before or not. Any other suggestions?

I need help writing a formula that looks up multiple referenced in the same column. The report lists an employee's name and then the project(s) he/she is working on beneath him/her in same column. The projects and employees are not constant. One month employee A will be listed first and then...