Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jul 03, 2020 03:19 AM
I have 5 fields with different time formats which can be date, hours, minutes, seconds…
ex:
Field 1: 4 days
Field 2: 2 hours
Field 3: 2,5 days
Field 4: 15 mins
Field 5: 25 seconds
Field 6 = sum (field 1 + field 2+ field 3+field 4+ field 5 ) with ‘days’ format
Which formula I can use in this situation ?
Solved! Go to Solution.
Jul 04, 2020 09:34 PM
Hi @Kendy511,
Since each field has its own format, it would be best if you convert each Field to the final format you want in the result. So it would become something like
Field 1 + (Field 2 / 24) + Field 3 + (Field 4 / 1440) + (Field 5 / 86,400)
Jul 04, 2020 09:34 PM
Hi @Kendy511,
Since each field has its own format, it would be best if you convert each Field to the final format you want in the result. So it would become something like
Field 1 + (Field 2 / 24) + Field 3 + (Field 4 / 1440) + (Field 5 / 86,400)
Jul 05, 2020 03:30 AM
I have thought about this way with if condition for each time format. thought we can have another way simplier in setting but seems I have to get traditional forumula
Again thanks for advices!