Have a look at this old thread of Joe Mako's for a couple of ideas (whatever happened to Joe - used to be a real regular?). Best way may be use James's solution for regular week days and a supplementary table like I suggested for public holidays.
Thanks Richard for the reply, appreciated.
I'm not good enough in finding out the formulas, I tried to do it but with no success.
I'm looking for a time difference in minutes. The above link point out to day difference.
I'm attaching my Excel file, if anyone could help.
Date diff.xls 21.0 KB
I'm sure it's doable in Tableau using an approach based on the thread I sent you - but definitely a bit of work and not trivial. I might try to put some more hints together when I get a minute.
But before I do - just one other thought. What is your real data source? Is it Excel, or was that just some sample data? The reason I ask is that if your data really is coming from Excel, you might find it easier to do this by using Excel formulas to create an extra column in your source data.
The real date source is Excel.
I'll have a look as well how to do it in excel.
Just wanted to check. How'd yall do on this effort? I'm embarking on the same effort.
The link goes to the main forums page. I tried to search for it but couldn't find it. Anyway we can get access to it now?
EDIT:Found the new link