Time Elapsed between two dates and two times

Hi,

I've been researching this for the past few hours but most of what i
found involved work weeks/shifts. i hope my problem is simpler. Given
a start date and a start time, end date and end time. I need to
calculate the remaining/elapsed time and output it in the following
format:

Time Remaining / Elapsed: # Days, # Hours, # Minutes.


Your help is truley appreciated.

Terry

re: Time Elapsed between two dates and two times

First of all, add the date and the time together, so that you have a start
date/time and an end date/time.

Then, see whether http://members.rogers.com/douglas.j....iff2Dates.html
helps.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Terry Shandal" <batoush@hotmail.com> wrote in message
news:8259b827.0405071316.217d3fcc@posting.google.c om...[color=blue]
> Hi,
>
> I've been researching this for the past few hours but most of what i
> found involved work weeks/shifts. i hope my problem is simpler. Given
> a start date and a start time, end date and end time. I need to
> calculate the remaining/elapsed time and output it in the following
> format:
>
> Time Remaining / Elapsed: # Days, # Hours, # Minutes.
>
>
> Your help is truley appreciated.
>
> Terry[/color]

re: Time Elapsed between two dates and two times

Worked great. Thank you very much for your help.

Terry



"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:<xKTmc.24042$urx.1661@news04.bloor.is.net.cab le.rogers.com>...[color=blue]
> First of all, add the date and the time together, so that you have a start
> date/time and an end date/time.
>
> Then, see whether http://members.rogers.com/douglas.j....iff2Dates.html
> helps.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
>
> "Terry Shandal" <batoush@hotmail.com> wrote in message
> news:8259b827.0405071316.217d3fcc@posting.google.c om...[color=green]
> > Hi,
> >
> > I've been researching this for the past few hours but most of what i
> > found involved work weeks/shifts. i hope my problem is simpler. Given
> > a start date and a start time, end date and end time. I need to
> > calculate the remaining/elapsed time and output it in the following
> > format:
> >
> > Time Remaining / Elapsed: # Days, # Hours, # Minutes.
> >
> >
> > Your help is truley appreciated.
> >
> > Terry[/color][/color]