KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
My table has sample data and I need to calculate business hrs between two timestamps in two columns. Business hrs : 9:00am to 5:00pm and neglect Saturday and Sunday, I am not considering public holidays. Can someone please provide some guidelines on how to achieve this? I want desired output as stated in column 3 , date is in format of : yyyy-mm-dd Created date Updated date Business hrs 2012-03-05 9:00am 2012-03-05 3:00pm 6 2012-03-05 10:00am 2012-03-06 10:00am 9 2012-03-09 4:00pm 2012-03-19 10:00am 2
Tags (comma-separated)
Save Edits
Cancel