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. 07-01-2009, 09:27 PM #1
    BineUSA
    BineUSA is offline Registered User
    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
    Reply With Quote Reply With Quote Share on Google+
  2. 07-09-2009, 07:54 AM #2
    xml-looser
    xml-looser is offline Registered User
    Join Date
    May 2009
    Posts
    60
    format cell with int value

    then use cell with value*24*60
    result are min
    Reply With Quote Reply With Quote Share on Google+
  3. 07-09-2009, 08:12 AM #3
    xml-looser
    xml-looser is offline Registered User
    Join Date
    May 2009
    Posts
    60
    format cell with
    [m]
    Reply With Quote Reply With Quote Share on Google+
  4. 07-09-2009, 10:20 AM #4
    Hack's Avatar
    Hack
    Hack is offline Registered User
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Moved To VB Classic (which also covers VBA)
    Reply With Quote Reply With Quote Share on Google+
« Previous Thread | Next Thread »

Similar Threads

  1. Convert EXCEL to XML
    By ryosaeb4 in forum XML
    Replies: 1
    Last Post: 04-30-2009, 08:03 AM
  2. Convert Excel to XML file
    By itsmaheshp in forum XML
    Replies: 4
    Last Post: 08-07-2008, 03:05 PM
  3. Convert Excel to pdf Without distiller
    By shivavalkyre in forum VB Classic
    Replies: 2
    Last Post: 03-07-2007, 08:30 AM
  4. Convert csv to Excel
    By cdias in forum Java
    Replies: 0
    Last Post: 06-22-2006, 06:21 AM
  5. convert a .xls text file to a Valid Excel file
    By neela in forum .NET
    Replies: 1
    Last Post: 01-12-2006, 06: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
  •  

Forum Rules
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