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

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=55445

 

[daniels012]

Enter this in to column E1
=(C1-B1)*1440


That should do the trick!
Michae

 

[Domenic]

Hi,

Try,

=(C1-B1+(C1<B1))

and custom format using [m]

Hope this helps!

 

[Freemini]

In your attached worksheet change hyphen in the date entries to a space.

ie in cell B5 enter 10/05 13:45 this should display as 10/05- 13:45

format cell E5 as general and amend your formula in cell E5 to read
=(C5-B5)*1440 and this will give the answer you are looking for i.e.
405


Hope this helps
Mike

 

[pjp007]

*In your attached worksheet change hyphen in the date entries to
space.
ie in cell B5 enter 10/05 13:45 this should display as 10/05- 13:45

format cell E5 as general and amend your formula in cell E5 to rea
=(C5-B5)*1440 and this will give the answer you are looking for i.e
405


Hope this helps
Mike *

Thanks Mike!! Your solution did it!!

Also many thnx to the others for the quick responses!!

Regards
P