Skip to main content
Question

Create a report that shows time between timestamps

  • August 18, 2021
  • 0 replies
  • 126 views

Hi,

I need to calculate the time between 2 timestamps

Time between:
  1. Lead Created and Call Attempt 1
  2. Call Attempt 1 to Call Attempt 2
  3. Call Attempt 2 to Call Attempt 3

What is the best type of report to do this?

What is the correct formula (assuming I need to add a formula)?

I think it may be similar to this thread, but I want to calculate days instead of hours...

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=31861&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer

If([Time Out] > [Time In],[Time Out] - [Time In],
Hours(24) - ([Time In] - [Time Out]))

Thanks,

Matt

------------------------------
Mathew Crist
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • August 18, 2021
Can you give a couple of example of the data you have and the result that you want?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------