Results 1 to 10 of 10

Multiply Hrs By Mins

Threaded View

  1. 09-04-2013, 06:42 AM #7
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,243

    Re: Multiply Hrs By Mins

    Or: =INT(A1*24)*7

    if you require each whole hour to be multiplied by 7.

    HTML Code: 

    Regards, TMS
    Last edited by TMS; 09-04-2013 at 06:47 AM.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If criteria match, multiply then sum across multiply worksheets
    By ciayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 02:20 PM
  2. [SOLVED] conditional formating to change cell colour when time has reached 30 mins then 60 mins
    By Laurab in forum Excel General
    Replies: 3
    Last Post: 05-22-2012, 03:26 PM
  3. Time Converter : Mins/Secs to Hours/Mins
    By jamesgsi1983 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2009, 09:02 AM
  4. Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins?
    By StargateFan in forum Excel General
    Replies: 8
    Last Post: 01-07-2006, 03:35 PM
  5. How to convert numeric value to mins and addimg mins to Hrs.
    By ramana in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2005, 06:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1