Converting Hours and Minutes to Just Minutes

C

cny2

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

Dave O

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!
 
C

cny2

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.
 
P

Pete

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

Pete
 
Top