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!
> Is ther a formula to convert hours and minutes to minutes
> eg 2:25 (2hrs 25minutes) = 145 minutes
sue walton - 17 Sep 2005 20:56 GMT
Thanks that worked perfectly
> Try custom formatting your cell as follows...
>
[quoted text clipped - 13 lines]
> > Is ther a formula to convert hours and minutes to minutes
> > eg 2:25 (2hrs 25minutes) = 145 minutes