C
Chuck Walsh
I know this is probably a very simple question for most, but I am a bit dense.
I need to use a time value that is generated by another formula to generate
a per hour average.
Example is a person works from 10: AM until 3:00 PM in my current
spreadsheet I have a start time colum and an end time colum. I also have a
time worked column that has a formula in it to get the total time worked. I
show a starting total of items say 100. I then put in an ending item total
say 200. I want to use a formula to calculate items per hour average. Right
now I have a base formula but I have to enter the time morked in each cell
manually. I want Exccell to take the value from the Dependent cell that
contains the formula that figurers time worked.
Can anyone help
I need to use a time value that is generated by another formula to generate
a per hour average.
Example is a person works from 10: AM until 3:00 PM in my current
spreadsheet I have a start time colum and an end time colum. I also have a
time worked column that has a formula in it to get the total time worked. I
show a starting total of items say 100. I then put in an ending item total
say 200. I want to use a formula to calculate items per hour average. Right
now I have a base formula but I have to enter the time morked in each cell
manually. I want Exccell to take the value from the Dependent cell that
contains the formula that figurers time worked.
Can anyone help