Time Formmating

[#1]

Hi Community

Can you ugently assist me .i have a create date field which shows something like this " 23445 " bu i want it to show "06:08:00 am/pm"

See the attached .

Regards

Mutshidzi

[sunny_talwar]

Is this in seconds? If it is, then may be this:

=Time(TimeField/(60*60*24))

[Chanty4u]

Try  Date(Field,’hh:mm:ss’)

interval(timefield ,'hh:mm:ss')

[its_anandrjs]

Try this

=Time(23445,'hh:mm:ss TT')

Regards

Anand

[Chanty4u]

try

1)

Date(Field,’hh:mm:ss TT’)

interval(timefield ,'hh:mm:ss TT')

=Interval(Timestamp#('urfield','time format'),'hh:mm:ss TT')

[#6]

Hi Guys

let me give a good example of my issue ,

253 suppose to show 00:02:53

20904 suppose to show 01:09:04

Thanks

[Chanty4u]

might be

=Time(Interval#(Time, 'hh:mm:ss'))

or

Time(maketime( Left(A1,2), RIGHT(A1,2)), 'hh:mm:ss') as Time

[Chanty4u]

Have a look at the HELP, search for 'format codes' and 'date and time functions'.

[Kushal_Chawda]

try this,

Time(Time#(num(TimeField,'000000'),'hhmmss'),'hh:mm:ss TT')