This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Expression to calculate hours worked based on timestamps?

Posted on 03-07-2020 07:22 AM
tcanelli
New Member
Reply posted on --/--/---- --:-- AM

I’d like to add a virtual column to calculate hours worked based on the check in timestamp and check out timestamp. I thought I’ve seen similar expressions posted in the community but couldn’t find any. Help is appreciated. Thanks

2X_1_1d31e7035820c24b7e325b6653365e820e73c705.jpeg

0 4 386
Topic Labels
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
MultiTech
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

check out TOTALHOURS()

TOTALHOURS([Finish Timestamp] - [Start Timestamp])

Posted on --/--/---- --:-- AM
tcanelli
New Member
In response to MultiTech
Reply posted on --/--/---- --:-- AM

2X_3_3ca6253b820ecb86976d9622c3f915346f8d14ca.jpeg

Why does it show as a negative? The checked in time was 3/7 at 9:54:01

I need to display as 41 minutes, or 8 hours (if that had been the case).

0 Likes

Posted on --/--/---- --:-- AM
tcanelli
New Member
In response to MultiTech
Reply posted on --/--/---- --:-- AM

I fixed the negative issue - had the expression in wrong order.

Posted on --/--/---- --:-- AM
MultiTech
Gold 4
Gold 4
In response to tcanelli
Reply posted on --/--/---- --:-- AM

My problem as well many times.

Top Labels in this Space