How to have the option of working with 2 different fields - one based on the other?

[horees]

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.

	Time-Days	Time-Hours
Case 1	1 (entered)	24 (calculated)
Case 2	2 (calculated)	48 (entered)

<TBODY>
</TBODY>

 

[horees]

Any Recommendations?

 

[horees]

any alternative ideas?

 

[horees]

any brainstorming of other solutions?

 

[horees]

Any Crazy Ideas? I don't want to force entry using either hours or days. I need to give the user the freedom to use whatever the units he likes.
We can think about formulas or vba code.

Thank you

 

[galt13]

Sample data?

 

[horees]

so I want the user to enter either Days OR Hours (one of the other)
and the excel should calculate the other
The problem is that some users plan in hrs, while others plan in days! and in both situation, I need to calculate the other. (keeping in mind that I want some sort of cell protection to the calculated durations)


Thank you

Plan	Duration, Days	Duration, Hrs
A	1	24
B	2	48
C	1	24
D	3	72

<TBODY>
</TBODY>

 

[shift-del]

The problem is that some users plan in hrs, while others plan in days! and in both situation, I need to calculate the other.

Why?

I would suggest something like this:

Arbeitsblatt mit dem Namen 'Tabelle1'
	A	B	C	D
1	duration days	duration hours		duration (hours)
2	2			48
3		20		20

<tbody>
</tbody>

Zelle	Formel
D2	=IF(COUNT(A2:B2),IF(A2,A2*24,B2),"")

<tbody>
</tbody>

Diese Tabelle wurde mit Tab2Html (v2.4.1) erstellt. ©Gerd alias Bamberg

<tbody>
</tbody>

 

[horees]

Perfect, got the idea.
Thanks alot