Skip to main content

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 ?

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)

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)


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!

Reply


Terms & Conditions