If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What function do I use to convert "time" to minutes?
I'm adding enroute times together using your basic XX:XX which is separated
by the colen. The total time will come to, say, 1:35 total time (one hour and 35 minutes). I want the cell to display, however, 95 minutes. Can this be done? Pete |
#2
|
|||
|
|||
=A1*24*60
format as general, or if you don't neet integer minutes but just want to display minutes use a custom format like [mm] -- Regards, Peo Sjoblom "petek" wrote in message ... I'm adding enroute times together using your basic XX:XX which is separated by the colen. The total time will come to, say, 1:35 total time (one hour and 35 minutes). I want the cell to display, however, 95 minutes. Can this be done? Pete |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert time to date? | Leslie Isaacs | Running & Setting Up Queries | 2 | February 27th, 2005 09:38 PM |
Convert Text Time to Time | mdalby | General Discussion | 2 | September 22nd, 2004 06:52 PM |
Time in Text- want to convert it | Neil | Worksheet Functions | 5 | September 15th, 2004 01:32 PM |
Time Function | Tony Johnson | Worksheet Functions | 1 | January 8th, 2004 03:40 PM |
FUNCTION to convert numbers to letters | Karen | Worksheet Functions | 4 | September 22nd, 2003 08:14 PM |