# Time Calculation Handlebar Help

**URL:** https://connective.celigo.com/t/time-calculation-handlebar-help/4564
**Category:** Integrator.io
**Tags:** handlebars
**Created:** [May 15, 2025, 8:06pm UTC](https://connective.celigo.com/t/time-calculation-handlebar-help/4564 "2025-05-15T20:06:46Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Brad\_Wilcox](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@Brad\_Wilcox](https://connective.celigo.com/u/Brad_Wilcox)
#### Post date: [May 15, 2025, 8:06pm UTC](https://connective.celigo.com/t/time-calculation-handlebar-help/4564/1 "2025-05-15T20:06:46Z")

</div>

I have the following Handlebar that calculates the number of hours worked on a job. (Trust me it works). v\_NS\_Time is populated by a result mapping in a previous step.

{{divide v\_NS\_Time 87.5}}

Now I want to use this value to calculate an ending date/time field.

Previously I was defaulting an end date/time to 1/2 hour with the following Handlebar

{{dateAdd (timestamp) "1800000"}}

When I try to replace the "1800000" with "360000" multiplied by the handlebar above, then nothing gets mapped as I want it to be. Here is the handlebar that I tried.

{{dateAdd (timestamp) {{multiply 3600000 {{divide v\_NS\_Time 87.5}}}}}}

Thanks for any help.

---

<div class="post-metadata">

### Author: ![Mark-IOCustomFlows](https://avatars.discourse-cdn.com/v4/letter/m/71c47a/32.png) [@Mark-IOCustomFlows](https://connective.celigo.com/u/Mark-IOCustomFlows)
#### Post date: [May 15, 2025, 8:38pm UTC](https://connective.celigo.com/t/time-calculation-handlebar-help/4564/2 "2025-05-15T20:38:42Z")

</div>

try this:

```auto
{{dateAdd (timestamp) (multiply 3600000 (divide v_NS_Time "87.5"))}}

```

 ![The image shows a Playground interface for editing and previewing a Handlebars template using a JSON record. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/b461257b16dc629b26fb3e8fbef8b4a095829666.png)

Let us know if it works, thank you!

---

<div class="post-metadata">

### Author: ![Brad\_Wilcox](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@Brad\_Wilcox](https://connective.celigo.com/u/Brad_Wilcox)
#### Post date: [May 15, 2025, 8:41pm UTC](https://connective.celigo.com/t/time-calculation-handlebar-help/4564/3 "2025-05-15T20:41:57Z")

</div>

That worked great and it actually didn't need the quotes around the 87.5 value.

Thank you..