Search results

Thank you very much this is so helpful.

Thank you for looking at this

Thank you, 1) the times are valid, but I had to change some from 1:00 am to 25:00, for example, for another macro I have to work 2) still max 24 hours in a day 3) some shift time occurs during the night (after 5pm), which would likely fall out of range and not be counted unless they...

Happy New Year! I need help calculating total minutes within a time range (including start and finish time) on certain weekdays. Please see attached file. Thank you!

Thank you, I noticed some of the time spans are not reflected in the chart correctly. I highlighted them. Thanks again

Now I have a problem - the data was sent to me in a different format and that seems to be causing a 'type mismatch'.

Thank you immensely for this, it is amazing. In version 1, how do I delete the red mark (comments/notes) that are on every bar?

wow, this is amazing. I wish I knew how to do this - I have been traveling so my apologies for not responding sooner. I will need to show data over midnight. I also have another request :) Is it possible to add the initials as shown on the chart on Jan 3? thank you very very much.

I was given data and instructed to provide a bar chart showing duration of an event against hours of the day. Each bar should be colored to match the location of the event. It was being completed manually by the prior employee. I attached a sample of the data (anonymized) as well as what the...