minutes to hh:mm:ss format

system · June 4, 2014, 1:59pm

hi
Iwant to convert a number (Minutes) into HH:MM:SS (00:00:00) format could any one help me with this … as i searched i the web i got the converstion from seconds… how could i do with Min please

chinny (BOB member since 2014-06-04)

MarkP · June 4, 2014, 2:00pm

Welcome to B B!

What version/tool are you using? e.g Webi 4.1 SP2, Deski 3.1

system · June 4, 2014, 2:09pm

its webi 4.1

chinny (BOB member since 2014-06-04)

MarkP · June 4, 2014, 2:23pm

OK, so we need to get a moderator to move this post to the Webi forum first then.

What’s your starting point and we can get to the end point from there.

system · June 4, 2014, 2:25pm

Done 8)

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

system · June 4, 2014, 2:34pm

so where i need to check my reply for this now please ? i m new here

chinny (BOB member since 2014-06-04)

system · June 4, 2014, 2:50pm

Right here, in this topic, nowhere else

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

MarkP · June 4, 2014, 4:41pm

So, now we’re in the right forum (thanks Marek), what are you starting from? Do you have a numeric object in minutes that you want to convert to hours and minutes?

system · June 4, 2014, 6:02pm

Yes I got a numeric object displaying in min ( eg: 39,456 ) I want end result iin hh:mm:ss format

thanks in advance

chinny (BOB member since 2014-06-04)

MarkP · June 5, 2014, 9:07am

I assume from your example that it will always be whole minutes?

In which case you would need:

=FormatNumber(Floor([WholeMinutes]/60);"00")+":"+FormatNumber(Mod([WholeMinutes];60);"00")+":00"

Where WholeMinutes is the object that contains the number of minutes that you want to parse out.

So 39,456 would become 657:36:00

Is that what you’re after?

system · June 5, 2014, 1:41pm

thanks its working

chinny (BOB member since 2014-06-04)