Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|