Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Improve Convert function in Excel | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
How do I convert Military Time to minutes? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions |