Formula calculating hours and minutes

HCL Domino Domino Forum
1

Hi have a formula thatv calculates the total number of minutes from two sets of 2 fields (total of RespHour_1 and RespMinutes_1 subtracted from total of RespHour_2 and RespMinutes_2). The result is a total in terms of minutes. What I would like to do is render the minutes in hour(s) and minutes in the calculation such if the total is 90 minutes then display 1 hour and 30 minutes to the closest 15 minutes.

I have a formula that takes me as far as the total number of minutes. Can anyone advise as to how I could accomplish this?

Thanks,

Dan

Here is the formula code:

RespHour_1 := 60 * @TextToNumber(Hour_1);

RespMinutes_1 := @TextToNumber(Minutes_1);

RespTime_1 := RespHour_1 + RespMinutes_1;

RespHour_2 := 60 * @TextToNumber(Hour_2);

RespMinutes_2 := @TextToNumber(Minutes_2);

RespTime_2 := RespHour_2 + RespMinutes_2;

TotRespTime := RespTime_2 - RespTime_1;

TotRespTime

The fields referenced are combobox type.

2

Subject: Formula calculating hours and minutes …

Here’s a formula that will do what you want, I think.

t := 100;

@Text(@Integer(t/60)) + “:” + @Text(@Modulo(@Round(t;15);60));

HTH

3

Subject: RE: Formula calculating hours and minutes …

Thanks Simon that works for me.