Martinpetersson
New Member
- Joined
- Apr 27, 2022
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
I’m creating a tact time board and I’m trying to get an automatic updated cell with remaining work hours left on the work week.
For an example.
We work straight from Sunday 10 pm to Friday 2.30 pm
Our goal is to produce 12000 pieces in that time frame. (Approximately 113 hours)
I already have a live updated cell that shows how many pieces we have produced so far this week and also one cell that shows how many pieces there are left to produce.
I also have one cell that shows the tact we have produced in during the actual day. (Ex. 96 pieces per hour during this day)
I now want excel to calculate how many pieces we need to produce/hour during the hours that are left of this week.
If I only could get a cell that automatically shows spent time since Sunday 10 pm and remaining time to Friday 2.30 pm then it will work.
Please help.
Martin
For an example.
We work straight from Sunday 10 pm to Friday 2.30 pm
Our goal is to produce 12000 pieces in that time frame. (Approximately 113 hours)
I already have a live updated cell that shows how many pieces we have produced so far this week and also one cell that shows how many pieces there are left to produce.
I also have one cell that shows the tact we have produced in during the actual day. (Ex. 96 pieces per hour during this day)
I now want excel to calculate how many pieces we need to produce/hour during the hours that are left of this week.
If I only could get a cell that automatically shows spent time since Sunday 10 pm and remaining time to Friday 2.30 pm then it will work.
Please help.
Martin