Hiya,
I have a spreadsheet of staff hours where Column I gives me the numeric value and Column K the type of hours (standard, regular, overtime etc). My boss would these values in their own columns.
Can anyone advise what formula to use for this?
I have attached an example spreadsheet.
Thanks
Bookmarks