Data Foemate

[vanderson009]

I have two fields in table, Metrics and Values, Data look like image that i have uploaded. I have created one more column as formate. metrics which are in red colour having number values, metrics which are in yellow colour having Time values and metrics which are in green colour having days values.

Metrics which are in yellow colour having Time values but it actual in number format and i want to convert it into time format as hh:mm:ss.

Please help me how can i change number format into time.

Thanks,

Villyee.

[Gysbert_Wassenaar]

If the Values is 73 then what should it look like in Time format?

[Chanty4u]

chk dis

Converting time to number : hhhh:mm:ss towards number,decimal

Re: number to time converstion

Convert number values into time

[Kushal_Chawda]

Time value in number is in second or in minute?

If it is in Seconds then try below

=if(Format='Time' ,num(Floor($(vSec)/3600),'00')&':'&num(floor(Mod($(vSec),3600)/60),'00')&':'&Mod(Mod($(vSec),3600),60),Value)

replace $(vSec) by Value

[MarcoWedel]

Hi,

maybe something like this?

table1:
LOAD Metrics,
    Pick(Match(Formate,'Number','Time','Days'),Values,Interval(Values/24/60,'hh:mm:ss'),Dual(Values&' d',Values)) as Values
Inline [
Metrics,Values,Formate
AAAA,23,Number
GGGG,73,Time
LLLL,54,Days
];

(assuming your time values are minutes as you did not specify)

hope this helps

regards

Marco