Convert Minutes to HH:MM

[plextor]

Does anybody have a good formula to convert Minutes to Hours:Minutes ?

Thanks,
Brian

 

[synapsevampire]

Create a formula like:

numberVar dur;
numberVar hrs;
numberVar min;
stringVar hhmm;

dur := {Table.Minutes};

hrs := Truncate(dur/60);
min := Remainder(dur,60);

hhmmss := totext(hrs, "0&quot + ":" + totext(min, "00&quot ;
hhmmss

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Naith]

Convert SynapseVampire's hhmmss to hhmm and you'll be good to go.

 

[plextor]

Thanks for your help! I greatly Appreciate it

 

[synapsevampire]

Thanks Naith, I was bastardizing a HHMMSS formula...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com