# Calculating the number of minutes between days

J

#### 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!

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

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

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

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

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.

## 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.