Hello everybody,</SPAN>
I’m creating an excel sheet will be used as template for data entry. One of the fields is time.</SPAN>
Unfortunately, the time unit isn’t standard here, so some people use DAYS, other use HRS.</SPAN>
In both cases, I need to have 2 fields for time for both units. So, is it possible to tell the Excel somehow if the use used the column of Time-Days, calculated the Time-Hours, and if the user used the Time-Hours, calculate the Time-Days?
At the same time, I want to keep the formulas in both fields unchanged (so if someone used the field Time-HR, I want the field still have the formula to convert to HR in cases that the user use the Time-Days)
Thank you</SPAN>
Note: The user won't work with 2 units at the same time at the same sheet...so the data entry will be using the same unit, but still we need to calculate the other.
<TBODY>
</TBODY>
I’m creating an excel sheet will be used as template for data entry. One of the fields is time.</SPAN>
Unfortunately, the time unit isn’t standard here, so some people use DAYS, other use HRS.</SPAN>
In both cases, I need to have 2 fields for time for both units. So, is it possible to tell the Excel somehow if the use used the column of Time-Days, calculated the Time-Hours, and if the user used the Time-Hours, calculate the Time-Days?
At the same time, I want to keep the formulas in both fields unchanged (so if someone used the field Time-HR, I want the field still have the formula to convert to HR in cases that the user use the Time-Days)
Thank you</SPAN>
Note: The user won't work with 2 units at the same time at the same sheet...so the data entry will be using the same unit, but still we need to calculate the other.
Time-Days | Time-Hours | |
Case 1 | 1 (entered) | 24 (calculated) |
Case 2 | 2 (calculated) | 48 (entered) |
<TBODY>
</TBODY>