Text and min
Ok in cell a1 I have 01/03/05 09:30am
in cell b1 I have 01/04/05 11:30 am In cell c1 I want Minutes I am using the formula B1-A1 I have the cell formatted at [mm] to calculate total minutes which woudl give me in cell c1 1560 What can I do to have it say 1560 min? |
Try format as [mm]" min"
-- Regards, Peo Sjoblom "Michaela" wrote in message ... Ok in cell a1 I have 01/03/05 09:30am in cell b1 I have 01/04/05 11:30 am In cell c1 I want Minutes I am using the formula B1-A1 I have the cell formatted at [mm] to calculate total minutes which woudl give me in cell c1 1560 What can I do to have it say 1560 min? |
All times are GMT +1. The time now is 11:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com