Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
petek
 
Posts: n/a
Default 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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Improve Convert function in Excel Mike VV Excel Worksheet Functions 0 February 3rd 05 04:45 AM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM
How do I convert Military Time to minutes? Rachael Excel Worksheet Functions 1 January 6th 05 10:01 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM
convert 100 minute hour to a 60 minute hour Todd Excel Worksheet Functions 1 November 15th 04 06:14 PM


All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"