Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is this in seconds? If it is, then may be this:
=Time(TimeField/(60*60*24))
Try Date(Field,’hh:mm:ss’)
interval(timefield ,'hh:mm:ss')
Try this
=Time(23445,'hh:mm:ss TT')
Regards
Anand
try
1)
Date(Field,’hh:mm:ss TT’)
interval(timefield ,'hh:mm:ss TT')
=Interval(Timestamp#('urfield','time format'),'hh:mm:ss TT')
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
might be
=Time(Interval#(Time, 'hh:mm:ss'))
or
Time(maketime( Left(A1,2), RIGHT(A1,2)), 'hh:mm:ss') as Time
Have a look at the HELP, search for 'format codes' and 'date and time functions'.
try this,
Time(Time#(num(TimeField,'000000'),'hhmmss'),'hh:mm:ss TT')