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

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!

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

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

Pete

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