Time between 2 dates

[pjp007]

Hi,

I want to calculate the time (in minutes) between two dates. The forma
is: dd/mm-uu:mm

For example:

(column B) Time 1 = 10/05-13:45
(column C) Time 2 = 10/05-20:30

(column E) Time 2 - Time 1 should give 405 minutes

I attached the document.

Any suggestions on this one?
P

 

[Andy B]

Hi

Subtract the earlier from the later and format the result as [mm]

 

[JE McGimpsey]

Fortunately the attachment didn't come through.

Format/Cells/Number/Custom [m]

 

[Bob Phillips]

=(C1-B1)*24*60

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave R.]

=ROUND((A2-A1)*1440,2)

 

[cutter]

Hi
Try this formula in the cell where you want the answer to
be: =HOUR(C1-B1)*60+MINUTE(C1-B1)
Assuming Time 2 is in cell C1 and Time 1 is in cell B1
Format the cell where the answer is as a number with no
decimal places
This will work for the example you gave