Forum Discussion
Referencing multiple time ranges on excel
Hi
First you need a list-based table and not a cross tabular report.
Second because your smallest time granularity is 30 minutes your input must be always in 30 minutes intervals.
See my Power Query solution in attached file.
Hi,
Thank you so much for your time, I really appreciate it!
I am doing this to help the salaries department in my hospital who are currently doing this manually on a piece of paper. I am one of the employees here and have nothing to do with salaries but thought it would be great to digitize the overtime sheet.
In order for them to take it I need to make sure it looks the smae as what they have now or they wont accept it, Its a nightmare!
What I have created is an exact copy apart from the columns to the right which I have added.
Is there any way of making it work within the constraints of the workbook I have sent originally?
Again, I am so grateful for all your help with this!
Thank you
I created the output to be like the original.
Only the input is changed.
May be someone else has a solution that fits better with the original.
Thank you so much for all your help I really do appreciate it!
Richard
