Automatically saving value even though the formula changes with th

[Guest]

I have a Sheet (sheet 1) that changes each day based on TODAY() placed in C5.
My staff enter the beginning and end times of when they have completed a
specifc task. A formula
(=IF(B12=JIM!$C$5,IF(JIM!$D$8="","",(JIM!$D$9-JIM!$D$8)),"") on sheet 2
calculates how long it took them to do the task and then places the answer in
A1 on (sheet 2). My problem is, the formula on sheet 2 returns a different
answer at midnight, because it refers to A1 on Sheet 1 which changes everyday
based on TODAY in C1. So, every time the date changes at midnight, the
answer disappears on sheet 2. I want to be able to keep the answer on sheet
2 when the date has chagned from 4-1-07 to 4-2-07 on Sheet 1 and then just
proceed placing the next answer in on sheet 2 on 4-2-07, 4-3-07, 4-4-07,
etc.... Any suggestions? I hope I didn't make this too confusing to
understand. Thanks!!!!!!!!! - Jim

 

[Guest]

You have to enter the date. Best way is
Cell A1 - '4/14/07 as text
Cell B1 - =datevalue(A1)

B1 will be in time format so you can calculate time in other cells.