"John Coleman" wrote in
ups.com:


Does this work? Assume that D1 holds the time:

=VALUE(CONCATENATE(HOUR(D1),REPT("0",2 -
LEN(MINUTE(D1))),MINUTE(D1),REPT("0",2 -
LEN(SECOND(D1))),,SECOND(D1),REPT("0",3-LEN(FIXED(24*3600000*(D1-TIME(H
OUR(D1),MINUTE(D1),SECOND(D1))),0))),FIXED(24*3600 000*(D1-TIME(HOUR(D1)
,MINUTE(D1),SECOND(D1))),0)))

Hope that helps

-John Coleman

ok, my field is AB3 instead of D1 but still when I apply it on your
formula

=VALUE(CONCATENATE(HOUR(AB3),REPT("0",2 -LEN(MINUTE(AB3))),MINUTE
(AB3),REPT("0",2 -LEN(SECOND(AB3))),,SECOND(AB3),REPT("0",3-LEN(FIXED(24*
3600000*(AB3-TIME(HOUR(AB3),MINUTE(AB3),SECOND(AB3))),0))),FIXE D(24*
3600000*(AB3-TIME(HOUR(AB3),MINUTE(AB3),SECOND(AB3))),0)))

is says - formula error and it show to REPT

--

Bllich