Converting Hours and Minutes to Just Minutes
 

Does anyone have a formula for converting for example 1 hr 20 m to 80
minutes? Thanks for your help. Karen.


--
cny2
------------------------------------------------------------------------
cny2's Profile: http://www.excelforum.com/member.php...o&userid=25679
View this thread: http://www.excelforum.com/showthread...hreadid=498409

Converting Hours and Minutes to Just Minutes
 

The answer depends on the format of your data, and perhaps how the data
is stored. For instance, is it in the format of your example, 1 hr 20
m, contained as text in a single cell? If yes then you'll need to
parse the 1 and the 20 out separately so you can perform the math on
them.

Please post examples of your actual data!

Converting Hours and Minutes to Just Minutes
 

Here is what I am trying to accomplish:

In Column A (Time In) the cells are custom formatted using h:mm
In Column B (Time Out) the cells are also custom formatted using h:mm
In the Total Time Used Column the cells are custom formatted using
h:mm

The problem is for example:

Time in: 9:40 Time out: 11:15 Total time used:
1:35

I need the total time used column to format it as 95 minutes.

I will also be using military time. For example:

Time in: 14:05 Time out: 16:30 Total time used:
2:25

Total time column needs to format it as 145 minutes.

Thanks for your help! Karen.


--
cny2
------------------------------------------------------------------------
cny2's Profile: http://www.excelforum.com/member.php...o&userid=25679
View this thread: http://www.excelforum.com/showthread...hreadid=498409

Converting Hours and Minutes to Just Minutes
 

Format the "total time used" cell as Custom "[m] minutes", i.e.
everything within the quotes.

Pete

Converting Hours and Minutes to Just Minutes
 

It worked well! Thanks a lot for your help. Karen.


--
cny2
------------------------------------------------------------------------
cny2's Profile: http://www.excelforum.com/member.php...o&userid=25679
View this thread: http://www.excelforum.com/showthread...hreadid=498409