Time convert in 24 hours format

building reports webintelligence
1

Hi expert

I am using formula =formatdate(todate(formatNumber([time];“000000”) ;“HHmmss”) ;“hh:mm”)
Time result is coming 04:18 instead of 16:18

Could you support to get result in 24 time format.

BR
Sultan

2

hh = 12 hour time, HH = 24 hour time

=formatdate(todate(formatNumber([time];“000000”) ;“HHmmss”) ;“HH:mm”)

1 Like
3

Hi dtolley,

Thank a lot for your support.

It is working fine.