+ Reply to Thread
Results 1 to 4 of 4

macro not turning minutes to hours

  1. #1
    Registered User
    Join Date
    05-16-2008
    Posts
    23

    macro not turning minutes to hours

    this macro is not coverting minutes to hours. Also i don't know how to reformat the macro to give me hours. Can some one please help
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: macro not turning minutes to hours

    If you use code to add the formula =NOW then that time will alter as the workbook calculates. To avoid having to copy & paste special, use this instead
    Please Login or Register  to view this content.
    Where's the problem with the hours?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    05-16-2008
    Posts
    23

    Re: macro not turning minutes to hours

    The problem with the hours is its not moving from minutes to hours in both the diffence colums and assembly time. i thank you for you help

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: macro not turning minutes to hours

    Where is the time calculated, try to say in which macro & how. There's a lot of code to look through!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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