Results 1 to 2 of 2

Thread: Time difference in CR9 *Resolved*

  1. Aug 18th, 2003, 12:02 PM #1
    VB4fun
    VB4fun is offline

    Thread Starter
    Hyperactive Member VB4fun's Avatar
    Join Date
    May 2003
    Location
    too far from Fiji
    Posts
    342

    Time difference in CR9 *Resolved*

    Using CR9, VB6, .mdb

    I have two (date/time) fields in my db. I would like to place a formula in a CR report, which gives me the difference in "hh:mm" format...

    ie. field 1 = 8:00 a.m., field 2 = 10:45 a.m.; formula result would be "2:45" elapsed time

    Anyone have an idea how I write this ?
    Last edited by VB4fun; Aug 18th, 2003 at 05:54 PM.
    Talk does not cook rice.
    -Chinese Proverb
    Reply With Quote Reply With Quote
  2. Aug 18th, 2003, 05:54 PM #2
    VB4fun
    VB4fun is offline

    Thread Starter
    Hyperactive Member VB4fun's Avatar
    Join Date
    May 2003
    Location
    too far from Fiji
    Posts
    342
    fwiw

    Datediff("n",{tblTime.Start},{tblTime.Complete}) / 60

    where tblTime is the .mdb table, Start and Complete are the fields.
    Talk does not cook rice.
    -Chinese Proverb
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width