+ Reply to Thread
Results 1 to 2 of 2

Subtracting Values of Time

  1. #1
    Registered User
    Join Date
    01-08-2016
    Location
    USA
    MS-Off Ver
    2011
    Posts
    6

    Subtracting Values of Time

    I am making a user form to log in and log out students in a program. They choose and event and an event type then login. The time stamp that they log in as is represented in a cell. They then come back to the user form when they are done and log out. I need to subtract the log in value and the log out value to get a total time at the event. I will use that time and add it to the main spread sheet which shows all the students and the events they went to.

    Here is the code so far:


    Please Login or Register  to view this content.
    The Part I am working with is in bold, Private Sub Calculate Time

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,868

    Re: Subtracting Values of Time

    Please Login or Register  to view this content.
    this could lead to serious errors (If you count time not only in whole days).

    Not seeing the spreadsheet it is not easy to guess what is real problem, but see this:

    Please Login or Register  to view this content.
    Best Regards,

    Kaper

+ 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. subtracting time values
    By dwinters in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-12-2015, 10:47 AM
  2. [SOLVED] Adding / Subtracting TIME VAULES / UNITS (Not time of Day) - I'm lost ... [RESOLVED]
    By BaLLZaCH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2015, 10:02 PM
  3. Replies: 10
    Last Post: 11-08-2014, 04:51 PM
  4. (VBA) Problem with subtracting time values past midnight
    By exEExe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2012, 12:58 PM
  5. Replies: 3
    Last Post: 09-29-2007, 04:58 PM
  6. Subtracting time values
    By fishphone in forum Excel General
    Replies: 2
    Last Post: 06-27-2005, 01:29 PM
  7. SUBTRACTING TIME VALUES INSTEAD OF DECIMAL!!
    By Lexicon in forum Excel General
    Replies: 8
    Last Post: 04-19-2005, 04:06 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