# Sum Times

**URL:** <https://forums.knack.com/t/sum-times/9849>\
**Category:** Get Answers\
**Created:** [July 1, 2021, 7:04pm UTC](https://forums.knack.com/t/sum-times/9849 "2021-07-01T19:04:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ManuelPint42562](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/manuelpint42562/32/651_2.png) [@ManuelPint42562](https://forums.knack.com/u/ManuelPint42562)\
**Post date:** [July 1, 2021, 7:04pm UTC](https://forums.knack.com/t/sum-times/9849/1 "2021-07-01T19:04:31Z")

</div>

Hello I am trying to set up a Clock In Clock Out Employee Hours function

Using  
Date Time Field for&nbsp; TIME START.&nbsp; &nbsp; &nbsp;and TIME END

and then using a Formula Field TIME WORKED. for calculating the time between TIME END and TIMNE START.  
  
Now I would like to sum up each TIME WORKED for each of say, 7 days to calculate to the TOTAL HOURS worked, but it always returns a fraction of 24 hrs and never a true sum, like 49 hours.  
  
Is there a workaround?&nbsp; &nbsp; The TIMER field seems like we cant do too much with it except enter the date manually, which wont work - as we dont want the staff to edit their hours.

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![Wolfgang\_Brötz](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/wolfgang_br%C3%B6tz/32/1465_2.png) [@Wolfgang\_Brötz](https://forums.knack.com/u/Wolfgang_Br%C3%B6tz)\
**Post date:** [February 14, 2023, 7:02pm UTC](https://forums.knack.com/t/sum-times/9849/2 "2023-02-14T19:02:43Z")

</div>

Hi @ManuelPint42562, does the Equation field work for you?

 ![Screenshot 2023-02-14 3](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/8/81db1091649b7561613ba847d0c853a15f5cc1e3.png)  
 ![Screenshot 2023-02-14 2](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/1/15ce5c788a7dbcbb6604b4ae4809b41469a564b8.png)

---

<div class="post-metadata">

**Author:** ![GazM](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/gazm/32/2007_2.png) [@GazM](https://forums.knack.com/u/GazM)\
**Post date:** [August 12, 2024, 11:50am UTC](https://forums.knack.com/t/sum-times/9849/3 "2024-08-12T11:50:15Z")

</div>

@Wolfgang_Brötz - I cannot get the equation field to work for a similar situation. It always returns a zero. What are you suggesting I might have done wrongly?

I’d really like to calculate number of minutes. so calculating seconds and will (once working) convert to minutes in the equation.

thanks

![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/f/fce9bfc7b7e9be3cb0c99f9101a1271824b47397.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/8/8ea0d4c39aedabe8059009cc7f79486556a21dc9.png)

---

<div class="post-metadata">

**Author:** ![PeterG](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PeterG](https://forums.knack.com/u/PeterG)\
**Post date:** [August 12, 2024, 4:32pm UTC](https://forums.knack.com/t/sum-times/9849/4 "2024-08-12T16:32:41Z")

</div>

![Time Diff](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/7/71941530d5483bcfae8fd24d01ee648de81b2c41.png)  
 ![Time Diff Results](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/ee2b480da4a953e51bd1d245008c9b84a4e34a60.png)
