Text and min

M

Michaela

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating date and time 5
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
time_report_date-wise_employee-wise 6
reduce data points and average? 5
IF ARRAY with multiple conditions. 1
Conditional Time Calculation 10
Subtracting time...again 2
How do I count the number of blank cells 0

Top