(Budget) Need ideas for an optimal way to proceed

Copper Contributor

Hey everyone, I'm working in a hospital and we're asked to keep track of every overtimes, 1:1 surveillance, surplus, etc. (It's a really huge work charge for only 2 employees, thank you pandemic)

 

We're asked to do this in an Excel 2016 table (1 "transaction" = 1 row), by filling in every infos they ask.

 

Just fyi, here's approximatively what the required infos are : 

 

Department - Date - Time start - Time end - Break time - Type (overtime, surplus...) - Job title, etc.

 

Of course, I can copy/paste most of the time, but it gets quite tiring and I was simply wondering if you guys had any idea about how I could do what they ask in the most optimal way ? 

 

I was thinking about creating like a form, but it seems slower than copy/pasting...

 

Any suggestions ? I know there's a big lack of details, but any tips will probably help me.

 

Thanks a lot in advance !   

1 Reply