convert d hh:mm into mm in excel!!!


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: convert d hh:mm into mm in excel!!!

  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Red face convert d hh:mm into mm in excel!!!

    I 've got data in excel displayed in d hh:mm format and can't work with it. For calculations I need this enlapsed time in minutes. Had someone work with this, maybe a macro..??? Any help is appriciated! Thanks

    Sabine

  2. #2
    Join Date
    May 2009
    Posts
    60
    format cell with int value

    then use cell with value*24*60
    result are min

  3. #3
    Join Date
    May 2009
    Posts
    60
    format cell with
    [m]

  4. #4
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Moved To VB Classic (which also covers VBA)

Similar Threads

  1. Convert EXCEL to XML
    By ryosaeb4 in forum XML
    Replies: 1
    Last Post: 04-30-2009, 09:03 AM
  2. Convert Excel to XML file
    By itsmaheshp in forum XML
    Replies: 4
    Last Post: 08-07-2008, 04:05 PM
  3. Convert Excel to pdf Without distiller
    By shivavalkyre in forum VB Classic
    Replies: 2
    Last Post: 03-07-2007, 09:30 AM
  4. Convert csv to Excel
    By cdias in forum Java
    Replies: 0
    Last Post: 06-22-2006, 07:21 AM
  5. Replies: 1
    Last Post: 01-12-2006, 07:42 PM

Tags for this 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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center