User Profile
Clare76
Copper Contributor
Joined Jan 13, 2021
User Widgets
Recent Discussions
Re: Excel - calculating hours worked on single cell values
Hi Hans I posted earlier this year regarding an issue I had with our staff rota, where I needed to total monthly hours in an excel document based on shifts worked. You provided me with a formula and this has been incredibly helpful in calculating monthly work hours. My issue now is that I want to include holiday hours in the monthly total and can't figure out how to include this in the formula. I have attached an example. Any help gratefully received! (in the attached example a holiday shift is 8 hours) Kind Regards Clare9.6KViews0likes4CommentsExcel - calculating hours worked on single cell values
Hi I'm trying to figure out what I'm sure is a simple excel query. I need to calculate total weekly hours on a staff rota and the rota is formatted with each shift eg 09:00-17:00 in one single cell. Is there a way to sum these hours? Previously it was down manually but means there is room for error. I have seen other examples splitting the shift into two cells (start and end time) but my manager wants to keep the format as is. I've attached an example and would appreciate any feedback.Solved12KViews0likes36Comments
Recent Blog Articles
No content to show