Help

Formula sum different time format of all fields

Topic Labels: Formulas
Solved
Jump to Solution
1017 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kendy511
6 - Interface Innovator
6 - Interface Innovator

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 ?

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

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)

See Solution in Thread

2 Replies 2
Mohamed_Swella1
13 - Mars
13 - Mars

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!