Prev: hours / minutes
Next: declaration help please
From: JT on 27 Apr 2010 16:06
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
From: Helmut Meukel on 27 Apr 2010 16:25
MyHrs = Int(TtlMins / 60)
MyMins = TtlMins - MyHrs * 60

HTH.

Helmut.


"JT" <JT(a)discussions.microsoft.com> schrieb im Newsbeitrag
news:9AF56298-0C58-46C3-A447-BF0EA0519299(a)microsoft.com...
> 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


From: norie on 27 Apr 2010 20:01
Try this.
[code]
MyHrs = TtlMins \ 60

MyMins = TtlMins - MyHrs * 60
[/code]

From: Javed on 28 Apr 2010 03:33
On Apr 28, 5:01 am, norie <norie.mace...(a)tiscali.co.uk> wrote:
> Try this.
> [code]
> MyHrs = TtlMins \ 60
>
> MyMins = TtlMins - MyHrs * 60
> [/code]

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


 | 
Pages: 1
Prev: hours / minutes
Next: declaration help please