Please help me create a specific template sensor using a formula

Hello Flying_V_Ranch,

I’m sure that can be done. Also having someone or something writing it for you means the second it misbehaves, you will be struggling back to find someone to fix it for you.
The best way to learn is to just try. Run thru the docs on searching for other code that is similar and the template docs If you get stuck, come back with what you have done. Then we can see better what you exactly need.
How to help us help you - or How to ask a good question and Templating - Home Assistant.

And Welcome to the Home Assistant Forum.