Converting minutes into days/hours/minutes

[DLTaylor]

Hi

I have a value in minutes and I want to display this as days/hours/minutes. Is there a formula that will do this?

I also need to get a total in days/hours/minutes for several records - so want to be able to add any number of records and get a total time.

I am using crystal 7.

Thanks.

 

[Reebo99]

Local NumberVar TotalMins := 1440;
Local NumberVar Days := 0;
Local NumberVar Hours := 0;
Local NumberVar Mins := 0;
Days := Truncate(Truncate(TotalMins/60)/24);
Hours := Remainder(Truncate(TotalMins/60),24);
Mins := Remainder(TotalMins,60);
totext(Days,0,"&quot&" day(s) "&totext(Hours,0,"&quot&" hour(s) "&totext(Mins,0,"&quot&" min(s)";

Replace the item in bold with your field.

synapsevampire has a faq related to this faq767-3543



Reebo
UK

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)

 

[DLTaylor]

Thanks for this. I have tried it but am getting an error which says 'The remaining text does not appear to be part of the formula'. It highlights the problem as being with the & on the last line of the formula.

Thanks.

 

[Reebo99]

Which & ?

Reebo
UK

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)

 

[DLTaylor]

The first one in the last line of the formula:

totext(Days,0,"&quot&" day(s)

 

[Reebo99]

Do you have the complete :

totext(Days,0,"&quot&" day(s) "&totext(Hours,0,"&quot&" hour(s) "&totext(Mins,0,"&quot&" min(s)";

in the last line, or just :

totext(Days,0,"&quot&" day(s)

If the latter, it needs to be totext(Days,0,"&quot&" day(s)"

It works ok in my testing....

Reebo
UK

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)

 

[DLTaylor]

No I've got the complete thing:

totext(Days,0,"&quot&" day(s) "&totext(Hours,0,"&quot&" hour(s) "&totext(Mins,0,"&quot&" min(s)";

I'll have another look at it.

Cheers.

 

[zanthe99]

ToText((Truncate(Sum ({HISTORY_DETHIST_.QUANTITY})/24)),0) + " days, " +
ToText((Remainder (Sum ({HISTORY_DETHIST_.QUANTITY}), 24)),0) + " hours "


Don't know if this will help you, but I use this formula for a quantity field that I want turned into days and hours. The result looks like (17 days, 4 hours). Sometimes I can figure something out by looking at other formulas.