Skip to main content
Solved

Can something help?

  • August 17, 2020
  • 5 replies
  • 31 views
T

Hi, I am a new user… can someone help how to get the amount of the time duration?

Thanks,

Best answer by Nathalie_Collin

Thank you for your helping hand @ScottWorld.

Unfortunately, it’s not working… how I cut and pasted the formula is wrong?


Change the ‘minutes’ to ‘seconds’. It’s because you have the format in a time format. This formula is built well for a field with a format of Intiger. You’re looking for an output in duration so switching it to seconds will make the difference. So your formula would now read;

IF(
AND({End Time}, {Start time}),
DATETIME_DIFF({End Time}, {Start time}, 'seconds')
)

hth,
Nathalie@VAcePro.com

5 replies

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

Welcome to the community, @Takashi_Takiguchi!

If you’d like to return your result in minutes, this is the formula you would use:

IF(
AND({End Time}, {Start time}),
DATETIME_DIFF({End Time}, {Start time}, 'minutes')
)
T
T
  • Takashi_Takiguc
  • Author
  • New Participant
  • August 17, 2020

Welcome to the community, @Takashi_Takiguchi!

If you’d like to return your result in minutes, this is the formula you would use:

IF(
AND({End Time}, {Start time}),
DATETIME_DIFF({End Time}, {Start time}, 'minutes')
)

Thank you for your helping hand @ScottWorld.

Unfortunately, it’s not working… how I cut and pasted the formula is wrong?

Nathalie_Collin
Forum|alt.badge.img+18

Thank you for your helping hand @ScottWorld.

Unfortunately, it’s not working… how I cut and pasted the formula is wrong?


Change the ‘minutes’ to ‘seconds’. It’s because you have the format in a time format. This formula is built well for a field with a format of Intiger. You’re looking for an output in duration so switching it to seconds will make the difference. So your formula would now read;

IF(
AND({End Time}, {Start time}),
DATETIME_DIFF({End Time}, {Start time}, 'seconds')
)

hth,
Nathalie@VAcePro.com

T
T
  • Takashi_Takiguc
  • Author
  • New Participant
  • August 17, 2020

Change the ‘minutes’ to ‘seconds’. It’s because you have the format in a time format. This formula is built well for a field with a format of Intiger. You’re looking for an output in duration so switching it to seconds will make the difference. So your formula would now read;

IF(
AND({End Time}, {Start time}),
DATETIME_DIFF({End Time}, {Start time}, 'seconds')
)

hth,
Nathalie@VAcePro.com


Thank you very much for your help, Nathalie!

Yes, it calculated it correctly now! :slightly_smiling_face:

Cheers,
Taka

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

Thank you very much for your help, Nathalie!

Yes, it calculated it correctly now! :slightly_smiling_face:

Cheers,
Taka


Thanks, @Nathalie_Collins!

Yes, to summarize what Nathalie said above:

  • Use ‘minutes’ if you are looking for an integer result.
  • Use ‘seconds’ if you are looking for a duration result, because duration formatting is based on number of seconds. (You can also multiply any minute integers by 60 to yield seconds, too.)
Nathalie_Collin
Terms & ConditionsAccessibility statement