Skip to main content
Solved

Subtract fixed time from duration field

  • May 17, 2020
  • 2 replies
  • 83 views

Hello,
I’m trying to subtract a specific time (3:30 hours) from a duration field using formula that looks like this:
Difference field = IF({Ride duration}=3:30,0,({Ride duration}-3:30))
Basically, I want to subtract 3:30 hours from the duration field to know the difference between the times

What am I missing here?

Thanks in advance,
Liat :slightly_smiling_face:

Best answer by ScottWorld

I just posted about this a few minutes ago in another thread:

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • May 17, 2020

I just posted about this a few minutes ago in another thread:


  • Author
  • New Participant
  • May 18, 2020

Thank u!!!
that helped a lot!!!