Calculating the number of minutes between days

[Jennifer Duffer]

I need to calculate the number of minutes between two times on two different
days.

For example:

2/6/2008 12:35 p.m.
2/8/2008 4:17 a.m.

Any thoughts or direction I should go?

Thanks much in advance!

 

[Niek Otten]

=A1-B1, Format Custom as [m]

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to calculate the number of minutes between two times on two different
| days.
|
| For example:
|
| 2/6/2008 12:35 p.m.
| 2/8/2008 4:17 a.m.
|
| Any thoughts or direction I should go?
|
| Thanks much in advance!

 

[Sandy Mann]

=(A2-A1)*1440

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[N Harkawat]

=(SUBSTITUTE(A1,".","")-SUBSTITUTE(A2,".",""))*1440

assuming A1 and A2 contain the 2 dates

If the dates have no decimal points around am and pm you could simply
subtract one from another and multiply the result by 1440

 

[joec]

=A1-B1, Format Custom as [m] will work fine but remember to format your
source cells how you want them to display. Do not type am or pm if entering
time.

 

[David Biddulph]

Why not, Joe? If the OP wants 11:00 PM for one of her input cells and types
in only 11:00, the time would be treated as 11:00 instead of 23:00.
I happen to prefer using 24 hour time, but there's no reason not to use 12
hour times.