|
Automatically saving value even though the formula changes with th
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 -- Jim |
Automatically saving value even though the formula changes with th
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. "jpolzner" wrote: 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 -- Jim |
| All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com