Google Sheets: Calculate End Date & Time from Start Date & Time for given Duration
Hi,
I have a problem working with the excel formula to calculate the End Date & Time from Start Date & Time for given Duration.
Its a 24/7 work but there is a chance for festival and natural disaster holidays so will maintain the holiday list separately. We have 2 shifts a day. details as given below. Please someone help me to find out the deadline for each allotted working files with file working hours. thanks in advance.
Capture.PNG
Pl upload a sample file.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Originally Posted by kvsrinivasamurthy
spreadsheets/d/1MhfWpK16bR9yAwJzfvbLSYzmg9hu38lZkygQUL22MO4/edit?usp=sharing
I am not able to post the link so I have shared the key for google spreadsheet.
All registered users are able to upload a sample Excel file, instructions are given in the banner at the top of the page.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks