system
#1
Hi folks
does anybody know a way to display a time as hh:mm:ss?
In Excel I only have to provide the time in fraction of the day and format it as TIME.
0,5 thus is displayed as 12:00:00
Sadly this does not work with BO.
I could start the old game
hh = trunc(day*24)
and then mm and ss with MOD() function and so on. Not very convenient
…
But hopefully there is somethink like a format function.
Thanks for any help in advance
OpusDei (BOB member since 2009-08-20)
system
#2
Check Marek’s suggestion.
Jansi (BOB member since 2008-05-12)
system
#3
ok looks pretty much like a solution. Thank you very much. Although I had hoped that some sort of format option could be used.
OpusDei (BOB member since 2009-08-20)
system
#4
An idea just struck my mind: what if I put the logic in something like a function:
time_char = f()
public function f()
{
return FormatNumber(Floor(/3600) ,“00”) & “:” &
FormatNumber(Floor(Mod( ,3600)/60) ,“00”) & “:” &
FormatNumber(Mod(Mod( ,3600) ,60) ,“00”)
}
dono with BO but this is whar I would do by progging
can this be done in Bo?
OpusDei (BOB member since 2009-08-20)
system
#5
Hi,
As far as I know, it is possible to create user libraries with functions that can be used in DeskI. But not in WebI.
Check the content of the local folder userlibs.
I have never created such libraries so I can’t help you more but maybe this points you in the right direction.
Marek Chladny (BOB member since 2003-11-27)