+ Reply to Thread
Results 1 to 3 of 3

userform time diff calculations

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    userform time diff calculations

    Thanks to wideboyDixon for his help on my last post about userforms.


    I am looking to calculate the difference between 2 times (sometimes over a 24 hour period) - code below
    again I have it sorted on a sheet that works fine but cannot figure out how to formulate it on a userform

    the code below is what I use on a sheet, on the userform c9 would relate to textbox8 (stop time) and e9 relates to textbox11 (start time), I also have textbox9 for start date and textbox10 for end date, if these are required

    Please Login or Register  to view this content.
    Any help Appreciated

    scouse13

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: userform time diff calculations

    (end date + end time) - (start date + start time)

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    Re: userform time diff calculations

    Quote Originally Posted by AlphaFrog View Post
    (end date + end time) - (start date + start time)

    Please Login or Register  to view this content.
    Thanks AlphaFrog, But where do I put the code, TextBox12? or somewhere else?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] 2 questions time diff and multiple look up
    By sakmsb in forum Excel General
    Replies: 8
    Last Post: 10-02-2014, 01:22 PM
  2. [SOLVED] Create Macro, Userform or a searchbox to search data from table in excel in diff sheets
    By hanif in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-25-2014, 06:21 AM
  3. [Solved] Date time diff
    By iamskippy in forum Excel General
    Replies: 4
    Last Post: 11-06-2013, 01:50 PM
  4. [SOLVED] Macro to send mail via lotus notes diff people diff attachment
    By mangeshp4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2013, 03:01 AM
  5. Time diff cal
    By abirami in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-19-2010, 05:23 AM
  6. Way to Subtract Time From Time? Not Diff Between Times.
    By TomBrooklyn in forum Excel General
    Replies: 1
    Last Post: 07-31-2008, 08:57 PM
  7. Calculating diff in time
    By marvinks in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2007, 12:44 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1