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
|