

Contributor II
2017-09-22
10:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Converter Segundos em Dias, Horas e Minutos.
Srs.(as), Boa tarde!
Alguém pode me ajudar por gentileza?
Tenho um campo TotalSegundos (com o tempo todas em segundos) e preciso converter a duração para dias, horas e minutos.
TOTALSEGUNDOS =104880
RESULTADO = 1 dia, 5 horas e 8 minutos
Agradeço atenção!
3,536 Views
1 Solution
Accepted Solutions

Partner Ambassador/MVP
2017-09-22
11:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=interval(TOTALSEGUNDOS /60/60/24,'DD hh:mm:ss')
furtado@farolbi.com.br
5 Replies

MVP
2017-09-22
10:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
=Replace(Replace(Replace(Interval(Interval#(104880, 'ss'), 'D @ h # m &'), '@', 'day/s'), '#', 'hours'), '&', 'minutes')

Creator III
2017-09-22
10:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use a função interval(expressão, 'd hh:mm:ss')
3,219 Views


Contributor III
2017-09-22
11:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try with
Time( A, 'dd-hh-mm' )
regards
3,219 Views

Partner Ambassador/MVP
2017-09-22
11:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=interval(TOTALSEGUNDOS /60/60/24,'DD hh:mm:ss')
furtado@farolbi.com.br


Contributor II
2017-09-22
01:14 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
usei assim:
=interval(timestamp#(sum(TEMPOACESSOSEGUNDOS), 's'), 'D hh:mm:ss')
Agradeço pela atenção!
