Excel Formula please
 

Is ther a formula to convert hours and minutes to minutes
eg 2:25 (2hrs 25minutes) = 145 minutes

Try custom formatting your cell as follows...

Format Cells Numbers Custom Type:

[m]

or

[m]" minutes"

The first format will give you '145', whereas the second format will
give you '145 minutes'.

Hope this helps!

In article ,
"sue walton" wrote:

Is ther a formula to convert hours and minutes to minutes
eg 2:25 (2hrs 25minutes) = 145 minutes

Thanks that worked perfectly

"Domenic" wrote:

Try custom formatting your cell as follows...

Format Cells Numbers Custom Type:

[m]

or

[m]" minutes"

The first format will give you '145', whereas the second format will
give you '145 minutes'.

Hope this helps!

In article ,
"sue walton" wrote:

Is ther a formula to convert hours and minutes to minutes
eg 2:25 (2hrs 25minutes) = 145 minutes