MathewCrist

4 years agoQrew Member

# Create a report that shows time between timestamps

Hi,

I need to calculate the time between 2 timestamps

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

------------------------------

I need to calculate the time between 2 timestamps

**Time between:**- Lead Created and Call Attempt 1
- Call Attempt 1 to Call Attempt 2
- 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

------------------------------