Hi guys
Im completely confused and have no idea how to resolve my issue.
I have a workbook with 50 tabs.
I have a macro to join all tabs into a single output file,
this contains start and end times.
I have a breakdown of hours formula that I use so a 12 hour shift is broken down into the correct billing hours.
what I need is for the sheet to insert a row and populate it using the broken down hours.
so 11 hour night shift
this would break down into 2.5 Hours Day and 8.5 hours night.
so the output would need to be
Day 2.5 hours
Night 8 hours.
I have attached a sample file so you can understand better
https://icare24-my.sharepoint.com/:...ZLhw4tx2iAiakBgoy1wmg2JjH-KVhK4I5sqQ?e=X5NcsH
Im completely confused and have no idea how to resolve my issue.
I have a workbook with 50 tabs.
I have a macro to join all tabs into a single output file,
this contains start and end times.
I have a breakdown of hours formula that I use so a 12 hour shift is broken down into the correct billing hours.
what I need is for the sheet to insert a row and populate it using the broken down hours.
so 11 hour night shift
this would break down into 2.5 Hours Day and 8.5 hours night.
so the output would need to be
Day 2.5 hours
Night 8 hours.
I have attached a sample file so you can understand better
https://icare24-my.sharepoint.com/:...ZLhw4tx2iAiakBgoy1wmg2JjH-KVhK4I5sqQ?e=X5NcsH