hours / minutes
 

In my macro, I use the following code to return the total number of minutes
between 2 times:

TtlMins = Day2 - Day1
TtlMins = 545

What I want to do next is to return the number of hours (9) and the
remaining minutes (5) into 2 variables but I'm not having much luck

MyHrs = ????
MyMins = ???

If I try TtlMins / 60 - I get 9.03338 when all I want is 9 and then I want
to see 5 as the minutes left over

Any help or code suggestions would be greatly appreciated. Thanks for the
help

--
JT

hours / minutes
 

MyHrs = Int(TtlMins / 60)
MyMins = TtlMins - MyHrs * 60

HTH.

Helmut.


"JT" schrieb im Newsbeitrag
...
In my macro, I use the following code to return the total number of minutes
between 2 times:

TtlMins = Day2 - Day1
TtlMins = 545

What I want to do next is to return the number of hours (9) and the
remaining minutes (5) into 2 variables but I'm not having much luck

MyHrs = ????
MyMins = ???

If I try TtlMins / 60 - I get 9.03338 when all I want is 9 and then I want
to see 5 as the minutes left over

Any help or code suggestions would be greatly appreciated. Thanks for the
help

--
JT

hours / minutes
 

Try this.

hours / minutes
 

On Apr 28, 5:01*am, norie wrote:
Try this.

Code:

---

MyHrs = TtlMins \ 60

MyMins = TtlMins - MyHrs * 60


---

Also can try following:
MyHrs = TtlMins \ 60
MyMins = TtlMins mod 60