Skip to main content

I have a working formula in my table to calculate the job duration from "job start" to "job end". I am trying to use the same formula to calculate a job response time from "Job Creation date" to "Job start". The formula is as follows:


CONCATENATE(
FLOOR(DATETIME_DIFF({Job Start}, {Job Creation Date}, 'minutes') / 60), ":",
RIGHT("00" & MOD(DATETIME_DIFF({Job Start}, {Job Creation Date}, 'minutes'), 60), 2)
)

However, this doesn't seem to be working as I have a job created date of 20/06/2025 13:00 and a job start of 20/06/2025 13:08 and the result it is giving me is 0:52 - I cannot seem to get this formula to give me the result of 0:08 which is what the actual result should be.

My job duration formula works exactly the same way and gives me the correct answer. Job Duration formula is:

CONCATENATE(
FLOOR(DATETIME_DIFF({Job End}, {Job Start}, 'minutes') / 60), ":",
RIGHT("00" & MOD(DATETIME_DIFF({Job End}, {Job Start}, 'minutes'), 60), 2)
)
Job Start = 20/06/2025 13:08 Job end = 20/06/2025 13:32 and formula results = 0:24 which is correct.

 

Could someone please help point me in the right direction with the Job Response Formula?

Hi, ​@StaceyHMH 

Sample way to fix it

  1.   Your formula is correct for calculating time difference.
  2.    The issue is probably not the formula, but rather:
  • Time zone settings
  • Hidden seconds in the datetime field

  • Or Airtable misreading the time

 Call to my action

Please go to both {Job Creation Date} and {Job Start} fields:

  • Click the field

  • Select "Customize field"

  • Ensure “ Use same time zone for all collaborator” is checked 

  • Make sure both are formatted exactly the same (with time shown)

After this, test the formula again. If it still doesn’t work, let me know the exact format of both fields and I’ll walk you through it step-by-step like a friend 

Let me know how it goes!

You superstar! what a simple fix that i have been wracking my brains over!!! Thank you so much

Terms & Conditions