Calculations

Forum|Forum|1 year ago
April 29, 2024
1 reply
640 views

I am trying to create a time sheet to calculate hours worked etc. I can't seem to figure out how to get the hours to add up correctly, can someone please help me with this?

MSTIMESHEET42624Test.pdf

How to

This topic has been closed for replies.

T

Tariq Dar

Legend

Hello,

How are you doing the calculation? Are you using any formula? What fields are you using to calculate the hours? I can't promise any help, but I will review and try to find out if any basic issue might hamper your calculations.

~Tariq

E

Ernest22785044d8hpAuthor

Participant

I am in prepare for, properties, calculate and then sum(+) than pick what I want added, and it's not adding the punch in and out for both work and lunch correctly. See it says 26 hours instead of 8

try67

Community Expert

You can't use simple addition for this type of calculation. It requires using a script that converts the strings to Date objects, and then calculates the difference between them, then converts that back to an hour or decimal notation. This subject was discussed here many times in the past, including full code examples. Try searching around using some relevant keywords and you're bound to find some information.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded