=CONCATENATE("00:0",L4,":",N4) 1

[metalboy]

I am using =CONCATENATE("00:0",L4,":",N4) to have a field show the time in 00:00:00 but when the secons from N4 is only 1 digit it will show 13:30:7 instead of 13:30:07.

Any ideas to get this to show correctly?

Kindest regards to everyone.

“It is a mistake to think you can solve any major problems just with potatoes.”
Douglas Adams

 

[macropod]

Hi metalboy,

Try:
="00:0"&TEXT(L4,"00")&":"&TEXT(N4,"00")

Cheers

 

[SkipVought]

Douglas Adams

Only problem with your approch is that the result is TEXT and it is NOT TIME!

I'd convert to TIME and then FORMAT. Your application will be much more versitile.
[tt]
=TIME(0,L4,N4)
[tt]
Use an appropriate TIME FORMAT or a CUSTOM FORMAT.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}