I have a Google Spreadsheet. I would like to write up a summary which would be as per following: The summary is based on the amount of hours of each person in the list, but some of the hours are counted as work related(WR), home related (HR), other related (OR) for each of the day in month.
What I like to achieve is that per day, different incident hours can happen, such as: 1.1 - WR 1 hour | OR 2 hours 30 mins
Is there a way for me to type WR in the cell so then when I do summary that 1 hour of WR would be counted to WR summary, please?
Aucun commentaire:
Enregistrer un commentaire