M
michelle
I'm sure this will be simple for most everyone but I can't wrap my arms
around it.
I hope I can explain properly. Basically I would like my spreadsheet to
perform 2 additional functions.
1. Currently with the formula I have my spreadsheet tells me when my order
will be done (Date and time) - My problem is when I enter the current date
and time and the spreadsheet it gives me finish date and time for my orders
but I have to manually update the pallets remaining on all of the following
orders. I run one order at a time.
I would like just to enter is the current date/time, and the count just on
the order I am currently working and have all the others update with it.
2. We work a 5 day week but sometimes on weekends. How do calculate to
include or exclude weekends?
Thank you in advance for any assistance. M
F6=IF(C6=0,C1,B1+B2+C6/24)
E6=+C6*D7
A B C D E F
1 DATE 7/10/2008 RTS
2 TIME 3:50 PM
3 ORDERS|#PLTS|REM. PLTS|HRS PER PLT|REM.HRS|FINISH TIME
4 1 16 0 2.2 0 RTS
5 2 42 0 1.5 0 RTS
6 3 42 39 1.5 58.5 7/13/08 2:20 AM
7 4 1 41 2.2 90.2 7/14/08 10:02 AM
8 5 1 42 2.2 92.4 7/14/08 12:14 PM
around it.
I hope I can explain properly. Basically I would like my spreadsheet to
perform 2 additional functions.
1. Currently with the formula I have my spreadsheet tells me when my order
will be done (Date and time) - My problem is when I enter the current date
and time and the spreadsheet it gives me finish date and time for my orders
but I have to manually update the pallets remaining on all of the following
orders. I run one order at a time.
I would like just to enter is the current date/time, and the count just on
the order I am currently working and have all the others update with it.
2. We work a 5 day week but sometimes on weekends. How do calculate to
include or exclude weekends?
Thank you in advance for any assistance. M
F6=IF(C6=0,C1,B1+B2+C6/24)
E6=+C6*D7
A B C D E F
1 DATE 7/10/2008 RTS
2 TIME 3:50 PM
3 ORDERS|#PLTS|REM. PLTS|HRS PER PLT|REM.HRS|FINISH TIME
4 1 16 0 2.2 0 RTS
5 2 42 0 1.5 0 RTS
6 3 42 39 1.5 58.5 7/13/08 2:20 AM
7 4 1 41 2.2 90.2 7/14/08 10:02 AM
8 5 1 42 2.2 92.4 7/14/08 12:14 PM