Still not getting how to convert seconds to hours and minutes 2

[fennerhillpro]

I am a newbee with Crystal and can't figure how to convert the formula below to HH:MM

time(int({ERLOG.DTIME}/100),remainder({ERLOG.DTIME},100),0) -
time(int({ERLOG.ATIME}/100),remainder({ERLOG.ATIME},100),0)

I get out put of 10,200.00 what I want to see is:

2:50 or 2hr 50 min

Can anyone help?

Thanks

 

[vidru]

Please acknowledge if the suggested solutions here thread767-769529 didn't work before starting a new thread.

-dave

 

[synapsevampire]

Here's the formula:

whileprintingrecords;
numbervar Dur := time(int({ERLOG.DTIME}/100),remainder({ERLOG.DTIME},100),0) -
time(int({ERLOG.ATIME}/100),remainder({ERLOG.ATIME},100),0);
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;
hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);
hhmmss := totext(hrs, "0&quot + ":" + totext(min, "00&quot + ":" + totext(sec, "00"
hhmmss

-k