# Expression based on hour meter count value

**URL:** <https://forum.inductiveautomation.com/t/expression-based-on-hour-meter-count-value/5448>\
**Category:** Ignition\
**Created:** [November 20, 2012, 9:26am UTC](https://forum.inductiveautomation.com/t/expression-based-on-hour-meter-count-value/5448 "2012-11-20T09:26:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brett\_Yeomans](https://avatars.discourse-cdn.com/v4/letter/b/35a633/32.png) [@Brett\_Yeomans](https://forum.inductiveautomation.com/u/Brett_Yeomans)\
**Post date:** [November 20, 2012, 9:26am UTC](https://forum.inductiveautomation.com/t/expression-based-on-hour-meter-count-value/5448/1 "2012-11-20T09:26:26Z")

</div>

I have a hour meter in a transaction group that records downtime to SQL, I’d like to have an additional column updated with a modified value of the hour meter - i.e. record the hour meter (duration) but then divide the hour meter value by 60 and multiply it by a tag value (line speed) to record waste for the line at the current speed to the new column.  
Any ideas on how to achieve this?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [November 20, 2012, 5:15pm UTC](https://forum.inductiveautomation.com/t/expression-based-on-hour-meter-count-value/5448/2 "2012-11-20T17:15:40Z")

</div>

I would make an expression item in the group that performs that calculation. Make the new expression item write to a new column in the database. The expression will be something like:`{Path/To/Hour/Meter} / 60 * {Path/To/Line/Speed}`