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, 10: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, 08: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, 09: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, 11:20 AM #4
    Hack's Avatar
    Hack
    Hack is offline Super Moderator
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Moved To VB Classic (which also covers VBA)
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista
    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, 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. convert a .xls text file to a Valid Excel file
    By neela in forum .NET
    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
  •  

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