Is ther a formula to convert hours and minutes to minutes eg 2:25 (2hrs 25minutes) = 145 minutes
S sue walton Sep 17, 2005 #1 Is ther a formula to convert hours and minutes to minutes eg 2:25 (2hrs 25minutes) = 145 minutes
D Domenic Sep 17, 2005 #2 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!
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!
S sue walton Sep 17, 2005 #3 Thanks that worked perfectly Domenic said: 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! sue walton said: Is ther a formula to convert hours and minutes to minutes eg 2:25 (2hrs 25minutes) = 145 minutes Click to expand... Click to expand...
Thanks that worked perfectly Domenic said: 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! sue walton said: Is ther a formula to convert hours and minutes to minutes eg 2:25 (2hrs 25minutes) = 145 minutes Click to expand... Click to expand...
