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!

=A1-B1, Format Custom as [m]

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jennifer Duffer" wrote in message
...
|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!

=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.
--
joec


"Niek Otten" wrote:

=A1-B1, Format Custom as [m]

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jennifer Duffer" wrote in message
...
|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!

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.
--
David Biddulph

"joec" wrote in message
...
=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.
--
joec

=(A2-A1)*1440

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Jennifer Duffer" wrote in
message ...
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!

=(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

"Jennifer Duffer" wrote:

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!