Hi all,
I looked into many topics but my doubt still exists
I need to calculate time according to working hours and working days (excluding sat and sun)
The problem is we have no start date or end date the process continues.
I have attached a sample sheet.
Coloumn A= names
Coloumn B=allotment time
Coloumn C=estimated time where in only extra hours is entered so that coloumn D shows actual date and time.(after adding C with coloumn B).
But this goes out of working hours some times like in example.
I want to use some formula to get result as coloumn E
i.e if the estimated time crosses 6 PM it takes next day in to account.
start time=9:00 Am and end time 6:00PM
Is this possible????
Bookmarks