Hi all
I need some help to get my excel doc to record the value of a cell at a set time:-
ie on the hour i want to record the value of cell A3 into cell D3
at 15mins past do the same but into cell D4 and so on. so i have the data for each 15 mins in an hourly period.
also i would like to see if it's possible to create a line chart that collects the data from one of these cell at set time periods ie every 4h it add the next value from cell D4 to a line graph
hope this makes sense
running office 2007
Regards
MPP
I need some help to get my excel doc to record the value of a cell at a set time:-
ie on the hour i want to record the value of cell A3 into cell D3
at 15mins past do the same but into cell D4 and so on. so i have the data for each 15 mins in an hourly period.
also i would like to see if it's possible to create a line chart that collects the data from one of these cell at set time periods ie every 4h it add the next value from cell D4 to a line graph
hope this makes sense
running office 2007
Regards
MPP