Hi, I am a new user… can someone help how to get the amount of the time duration?
Thanks,
Hi, I am a new user… can someone help how to get the amount of the time duration?
Thanks,
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')
)
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?
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
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
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.