I have start and end times in tables. I want to write a report that shows
the elapsed time in hours and minutes. I've got the elapsed time in minutes
(currently a string, but it seems as if I could use an integer as well). Is
there anything already written that will convert the minutes (using totals,
the minutes could be in the hundreds or thousands), to hours and minutes?

tia
las

On Thu, 19 Aug 2010 18:36:08 -0400, "LAS" <(E-Mail Removed)> wrote:

>I have start and end times in tables. I want to write a report that shows
>the elapsed time in hours and minutes. I've got the elapsed time in minutes
>(currently a string, but it seems as if I could use an integer as well). Is
>there anything already written that will convert the minutes (using totals,
>the minutes could be in the hundreds or thousands), to hours and minutes?
>
>tia
>las
>

Sure:

DateDiff("h", [start time], [end time]) & ":" & Format(DateDiff("n", [start
time], [end time]) \ 60), "00")

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

I don't think that will return valid data.

Try the following revision of John's expression (all one line) instead.
DateDiff("n", starttime, endtime)\60 & ":" & Format(DateDiff("n", starttime,
endtime) mod 60, "00")

StartTime = #13:50:00#
EndTime = #14:01:00#
?DateDiff("h", starttime, endtime) & ":" & Format(DateDiff("n", starttime,
endtime) mod 60, "00")
returns 1:00

The revised expression returns 0:11

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

John W. Vinson wrote:
> On Thu, 19 Aug 2010 18:36:08 -0400, "LAS" <(E-Mail Removed)> wrote:
>
>> I have start and end times in tables. I want to write a report that shows
>> the elapsed time in hours and minutes. I've got the elapsed time in minutes
>> (currently a string, but it seems as if I could use an integer as well). Is
>> there anything already written that will convert the minutes (using totals,
>> the minutes could be in the hundreds or thousands), to hours and minutes?
>>
>> tia
>> las
>>
>
> Sure:
>
> DateDiff("h", [start time], [end time]) & ":" & Format(DateDiff("n", [start
> time], [end time]) \ 60), "00")
>

On Sat, 21 Aug 2010 16:07:06 -0400, John Spencer <(E-Mail Removed)>
wrote:

>I don't think that will return valid data.
>
>Try the following revision of John's expression (all one line) instead.
>DateDiff("n", starttime, endtime)\60 & ":" & Format(DateDiff("n", starttime,
>endtime) mod 60, "00")

Thanks, John - had a brainfade there, your expression is of course the correct
one.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

Thanks for following up here. I was trying to fix it myself, but it was
going slow.

"John Spencer" <(E-Mail Removed)> wrote in message
news:i4pbla$eq3$(E-Mail Removed)...
>I don't think that will return valid data.
>
> Try the following revision of John's expression (all one line) instead.
> DateDiff("n", starttime, endtime)\60 & ":" & Format(DateDiff("n",
> starttime, endtime) mod 60, "00")
>
> StartTime = #13:50:00#
> EndTime = #14:01:00#
> ?DateDiff("h", starttime, endtime) & ":" & Format(DateDiff("n", starttime,
> endtime) mod 60, "00")
> returns 1:00
>
> The revised expression returns 0:11
>
> John Spencer
> Access MVP 2002-2005, 2007-2010
> The Hilltop Institute
> University of Maryland Baltimore County
>
> John W. Vinson wrote:
>> On Thu, 19 Aug 2010 18:36:08 -0400, "LAS" <(E-Mail Removed)> wrote:
>>
>>> I have start and end times in tables. I want to write a report that
>>> shows the elapsed time in hours and minutes. I've got the elapsed time
>>> in minutes (currently a string, but it seems as if I could use an
>>> integer as well). Is there anything already written that will convert
>>> the minutes (using totals, the minutes could be in the hundreds or
>>> thousands), to hours and minutes?
>>>
>>> tia
>>> las
>>
>> Sure:
>>
>> DateDiff("h", [start time], [end time]) & ":" & Format(DateDiff("n",
>> [start
>> time], [end time]) \ 60), "00")
>>