41.45 to time 'hh:mm'

[#1]

Hi All,

I have the time in this format

6

41.45

34.25

Now I want in 'hh:mm' format

and after this need to add all the Time in 'hh:mm'

[Anil_Babu_Samineni]

Now I want in 'hh:mm' format

and after this need to add all the Time in 'hh:mm'

I didn't understand the second part, You already have hh:mm then why do you need again

I tried like below i got like this, Do you like this

Load FieldName, Timestamp(Num(FieldName),'hh:mm') as FieldName1 Inline [

FieldName
6         

41.45   

34.25

];

And then Finally output seems

FieldName     FieldName1

6                     00:00

41.45              10:48

34.25              06:00

[vinieme12]

try

interval(Interval#('41.45','H.mm'),'H:mm')

[#4]

Actually It is showing

6 hours

41hours 45 min  but format is not ok and need in ' hh:mm'

Now     Want

6          6:00  

41.45    41:45

34:25    34:25

and then need to add all    as Total Time Taken to solve the ticket

[Anonymous]

Hi,

Firstly, you can not have your time above 24:00 hours. If it is 25:00, It will automatically change the time to 01:00.

If you want to change the number format, you can do it using Num() function. If you want to change the date format you can do it using date#() function. Please find the below script. Try removing date# and see the output. Modify it according to your requirement.

Load FieldName, date(date#(num(FieldName,'#,##0.00'),'hh.mm'),'hh:mm') as FieldName1
Inline [
FieldName
6         
25.45   
34.25

];

[tresesco]

Try like:

[#7]

thanks you so much