Display Static Time (Must NOT Change)

[Disarmonious]

1) I want the current time to display (can be in minutes) in cell N8 (and remain static, unchanged) when the user selects an item from a dropdown list in cell C8.

2) I want the current time to display (can be in minutes) in cell O8 (and remain static, unchanged) when the user selects a graphic/icon that is visible next to the cell.

3) I want cell M8 to display the number of minutes (only) after calculating the difference between the resulting time entries in cell N8 and cell O8.

If it means anything, cell N8 and cell O8 are not visible to the user. Cell C8 and the graphic/icon are only visible because they require the user to select.

I hope this can be accomplished using formulas that don't include circular references (unless the formulas using circular references work 100% of the time and the circular reference warning prompt can be disabled when booting Excel). I'm guessing this is a VBA task.?

Thank you, in advance!

 

[bobsan42]

I'm guessing this is a VBA task.?

Either that or type it in manually
It can be achieved without VBA but you need to set it up on each machine I think and I wouldn't recommend it as a permanent solution.
Formulas are normally recalculated so if you really need to avoid accidental changes to the values they need to be only values.
Clicking will also have to involve VBA, so you need it anyway,

 

[Disarmonious]

Either that or type it in manually
It can be achieved without VBA but you need to set it up on each machine I think and I wouldn't recommend it as a permanent solution.
Formulas are normally recalculated so if you really need to avoid accidental changes to the values they need to be only values.
Clicking will also have to involve VBA, so you need it anyway,

Thank you for the suggestion and feedback but I was looking for this to be a more automated process.

 

[Disarmonious]

bobsan42

Are you able to create the VBA coding and share so I can accomplish what I'm looking to do?

 

[Peter_SSs]

Maybe some/all of the things I mention below are not possible with your worksheet but please clarify.

1) I want the current time to display (can be in minutes) in cell N8 (and remain static, unchanged) when the user selects an item from a dropdown list in cell C8.

1. What should happen (in N8 &/or O8 &/or M8) if the user subsequently chooses a different value from the drop-down in C8?
2. What should happen (in N8 &/or O8 &/or M8) if the user, having chosen a value from the drop-down, subsequently clears the value from C8 leaving it empty?

2) I want the current time to display (can be in minutes) in cell O8 (and remain static, unchanged) when the user selects a graphic/icon that is visible next to the cell.

1. What should happen in any of the 3 cells mentioned above if the user subsequently re-selects that same graphic/icon for a 2nd, 3rd etc. time?

Also ..

1. Is it possible that the user selects the graphic/icon before choosing from the drop-down? In that instance does it change anything about what goes in N8 &/or O8?
2. Is this same process to be repeated on other rows as well or only row 8?

3) I want cell M8 to display the number of minutes (only) after calculating the difference between the resulting time entries in cell N8 and cell O8.

Assuming the above issues are resolved and that N8 is populated before O8 then M8 should be able to be achieved with the formula

=IF(COUNT(N8:O8)=2,(O8-N8)*1440,"")