BusinessObjects Board

Display number in a time format

Hello all,
I’m not sure if this is possible, but does anyone know how to display a number result (45,393.55 minutes) as a time format hh:mm:ss?


eddyc99 (BOB member since 2007-09-06)

Welcome to B:bob:B!

Please have a look here:

There is a similar conversion (from minutes to days, hours, minutes). You need to modify it to get hours:minutes:seconds
And check also this one:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

I think you can do that…use the following formula:

i am not giving you the whole formula. but u can define based on this:

=Floor([45,393.55]/60)+":"+Mod([45,393.55];60) etc…
u have to use “if” function there…

rj_srnth (BOB member since 2006-12-09)

Yes you will need to investigate using Floor as a command, but also doing multiples of 60, this will work out what you are trying to do.

However the very first thing I would suggest you do is to use the search function for both Webi and Deski and you will find the answer as this sort of question has been asked in the past.

plessiusa :netherlands: (BOB member since 2004-03-22)

Thank you all for the prompt replies. These have been very helpful. :smiley:

eddyc99 (BOB member since 2007-09-06)