Help! creating code for time to decimal calculations
 

Hello,

Sheet snippet:

COL A COL B COL C COL D
COL E COL F
DateTime StrtTime EndTotal Hours for
Day 70 Hr Clock Hours Remaining
ROW 1 9/1/2007 8:00 14:00
6.00 6.00 70 - 41.00
70 minues Col E running tally
ROW 2 9/2/2007 7:00 15:30
8.50 14.50 or
ROW 3 9/3/2007 8:00 15:30
7.50 22.00 29.00
ROW 4 9/4/2007 7:00 15:30
8.50 30.50
ROW 5 9/5/2007 0:00 0:00
0.00 30.50
ROW 6 9/6/2007 0:00 0:00
0.00 30.50
ROW 7 9/7/2007 6:00 14:30
8.50 39.00
ROW 8 9/8/2007 6:00 14:30
8.50 47.50
ROW 9 9/9/2007 7:00 15:30
8.50 47.50 Drops R2 Col E
ROW 10 9/10/2007 0:00 0:00
0.00 40.00 Drops R3 Col E
ROW 11 9/11/2007 6:00 14:30 8.50
41.00 Drops R4 Col E

For this posting, Col D, Col E, and Col F were entered manually to show the
correct values.
Col D needs to be in numeric form with 2 decimals and has calculation of Col
C - Col B
Col E needs to tally Col D, but in 8 day cycles.

What I'm looking for is some code that will convert the time values into
numbers with 2 decimal places (example, 30 seconds would be .5, 45 seconds
would be .75) and then, for Col E, to keep a running tally of Col D, but
only in 8 day cycles and then in Col F, a calculation to keep track of
remaining "time" (70 - latest Col E amount).

It's a lot and I'm not sure if it's feasible....but any help would be
appreciated.

Don

PLEASE DISREGARD this... IT WAS SENT TWICE
 

PLEASE DISREGARD THIS...IT WAS INADVERTENTLY SENT TWICE.

thanks,
Don



"DW" wrote in message
...
Hello,

Sheet snippet:

COL A COL B COL C COL
D COL E COL F
DateTime StrtTime EndTotal Hours
for Day 70 Hr Clock Hours Remaining
ROW 1 9/1/2007 8:00 14:00 6.00
6.00 70 - 41.00 70 minues Col E running tally
ROW 2 9/2/2007 7:00 15:30 8.50
14.50 or
ROW 3 9/3/2007 8:00 15:30 7.50
22.00 29.00
ROW 4 9/4/2007 7:00 15:30 8.50
30.50
ROW 5 9/5/2007 0:00 0:00 0.00
30.50
ROW 6 9/6/2007 0:00 0:00 0.00
30.50
ROW 7 9/7/2007 6:00 14:30 8.50
39.00
ROW 8 9/8/2007 6:00 14:30 8.50
47.50
ROW 9 9/9/2007 7:00 15:30 8.50
47.50 Drops R2 Col E
ROW 10 9/10/2007 0:00 0:00 0.00
40.00 Drops R3 Col E
ROW 11 9/11/2007 6:00 14:30
8.50 41.00 Drops R4 Col E

For this posting, Col D, Col E, and Col F were entered manually to show
the correct values.
Col D needs to be in numeric form with 2 decimals and has calculation of
Col C - Col B
Col E needs to tally Col D, but in 8 day cycles.

What I'm looking for is some code that will convert the time values into
numbers with 2 decimal places (example, 30 seconds would be .5, 45 seconds
would be .75) and then, for Col E, to keep a running tally of Col D, but
only in 8 day cycles and then in Col F, a calculation to keep track of
remaining "time" (70 - latest Col E amount).

It's a lot and I'm not sure if it's feasible....but any help would be
appreciated.

Don